Yesterday, we needed to import data from the AAA user of a database to the BBB user of another database. We did not know how to implement the data, but we knew how to use the exp/imp with low efficiency. today, I looked at the impdp description, which is simpler than exp/imp. I tried it again in the experiment database and succeeded. the command is as follows:
SQL> create directory exp_dump as 'd: \ exp ';
SQL> grant read, write on directory exp_dump to AAA;
Expdp AAA/AAA dumpfile = aaa % u. dmp directory = exp_dump logfile = aaaexpdp. Log job_name = exp_aaa;
Impdp AAA/AAA dumpfile = aaa % u. dmp directory = exp_dump remap_schema = aaa: BBB logfile = bbbimpdp. Log job_name = imp_bbb;
If you do not need to create a BBB user, it will be automatically created, and the data object will be created in the same tablespace as the AAA user, which is convenient and fast!
