Understanding of the deviation of the fromuser parameter in imp, impfromuser

Understanding of the deviation of the fromuser parameter in imp, impfromuser

There is always a problem when importing dump files in the past two days.

Symptom:

1. Run: imp xyz/xxx file = test. dmp log = imp_test.log fromuser = test1 touser = test2ignore = y commit = y buffer = 300000000 feedback = 10000

Note: This file is dump> GB.

2. It has been executed for a long time, but the final result is recorded in the log:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-64bit Production
With the Partitioning and Data Mining options

Export file created by EXPORT: V10.02.01 via conventional path

Warning: the objects were exported by TEST1, not by you

Import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. Importing TEST1's objects into TEST2
Import terminated successfully without warnings.

3. But no data in dump is imported to the test2 user.

Cause Analysis:

First, it is an understanding of the fromuser Parameter deviation in the imp command.

[Root @ vm-vmw4131-t ~] # Imp-help

FROMUSER list of owner usernames

In the help of the imp command, FROMUSER indicates the list of OWNER usernames. Correspondingly, the help of the exp command shows that the OWNER parameter indicates the same meaning:

[Root @ vm-vmw4131-t ~] # Exp-help

OWNER list of owner usernames

That is, this user refers to the user to which the object belongs.

Secondly, after consultation, the test1 user fromuser = test1 used in the above questions is the system account for executing exp, not the account of the database object, which can explain the cause of the above problem: because the data object account of the dump file is another account, not test1, use imp... fromuser = test1, the file dump will be retrieved to find objects belonging to the test1 user. After the full file scan, there is no object belonging to this user, therefore, the "Import terminated successfully without warnings" prompt ends normally.

Summary:

1. This import and export may not actually take into account the LANG and other character set environment variables.

2. imp's fromuser indicates the user to which the object belongs, not the user who executes exp export.

Oracle imp adopts the fromuser touser mode and prompts "importing xxx objects to xxx ";

The biggest possibility is that the table is too big, the table has an index, and the index is not small.

When importing database data to oracle in dos, the following error is reported: IMP-00034: Warning: FromUser "IIMS" is not found in the exported file"

I generally Import
Imp new username/password @ service name file = file to be imported fromuser = export username of database file touser = new username log = logs of the entire process of import
If you have any questions, run imp help = y to view more parameters.