Import the DMP file (no log files), early has to create table space, create a DMP file original user and new user b, given to create user permissions, use imp/1 b @ former file=F: \ xy DMP fromuser=a touser=b import, tip:

Through regular path by EXPORT: V11.02.00 create the EXPORT file

Warning: these objects are derived from a, not the current user

Has been completed ZHS16GBK character sets and AL16UTF16 NCHAR import
in a character setSuccessful termination of the import, there was no warning,

Exp again after export can't see the data,

CodePudding user response:

is very confused, please answer!

CodePudding user response:

top post, ask counsel, continue to wait, really worried

CodePudding user response:

to exp after export can't see the data,

How to export, guide?

CodePudding user response:

reference 3 floor selling fruit net reply:

to exp after export can't see the data,

How to export, guide?

Exp xy. DMP, use notepad to see the next, there is no data,
I don't think whether problem is the import, truly to enter the data

CodePudding user response:

reference 3 floor selling fruit net reply:

to exp after export can't see the data,

How to export, guide?

Is also a warning when import, these objects are derived from a, rather than the current user

CodePudding user response:

All the steps you cut some PIC,

CodePudding user response:

All the operation screenshot

CodePudding user response:

Exp is how export?

Look at the rc. DMP the size of the file,

CodePudding user response:

refer to the eighth floor selling fruit net reply:

exp is how export?

See rc. The DMP file size,

Exp username/password file=... The log=... The owner=...
The source file rc. DMP has hundreds of megabytes

CodePudding user response:

refer to the eighth floor selling fruit net reply:

exp is how export?

See rc. The DMP file size,

The operation of the above, it is the import process is there a problem

CodePudding user response:

Imp command prompt after you can see what

CodePudding user response:

You export the DMP file, no user data, or A user itself without the data,

CodePudding user response:

The

refer to 12 floor selling fruit net reply:

you export the DMP file, no user data, or A user itself without the data,

Thank you for your answer, you can tell the fine again, where is wrong, how should do?

CodePudding user response:

Has been confused, where is wrong, how to solve, please answer

CodePudding user response:

refer to the original poster superauditor response:

import the DMP file (no log files), the early stage of the created table space, create a DMP file original user and new user b, given to create user permissions, use imp/1 b @ former file=F: \ xy DMP fromuser=a touser=b import, tip:

Through regular path by EXPORT: V11.02.00 create the EXPORT file

Warning: these objects are derived from a, not the current user

Has been completed ZHS16GBK character sets and AL16UTF16 NCHAR import
in a character setSuccessful termination of the import, there was no warning,

Exp again after export can't see the data,

I personally feel that make sure have a data, if you have to see after imported into the b b, whether there is data in the final in judging the export problems, b