Oracle Import dump File ____oracle

The dump file exported with exp needs to be imported with imp command.

Exp USER1/PASSWORD@TESTDB1 file=c:\dump\newdump.dmp rows=y

Imp user1/password@testdb2 file=c:\dump\dump1.dmp fromuser=fromuser touser=user1

The Exp method cannot export a table of 0 data.

----------------------------------------------------------------

Import with the IMPDP command to set the dump file path First
Create or replace directory Dump_dir as ' d:\ together テストデータ ';
Grant read, write on directory test_dir to USER1;

Execute Import command
IMPDP User/pass Directory=dump_dir dumpfile=xxxxx.dmp
Tables=xxxx. XXXX encryption_password=dbdumppass skip_unusable_indexes=y table_exists_action=truncate content=data_only

Impdp
DMP files that are exported with EXPBP need to be imported using IMPDP.

Encryption_password=dbdumppass
Wallet Password

Skip_unusable_indexes=y
Skip_unusable_indexed whether to skip indexes that are not available

Table_exists_action=truncate
Table_exists_action actions performed when a table already exists

Content=data_only
When exporting/importing, we often have the need to export/import the table structure, or just want to export/import data. Fortunately, the data pump also provides this functionality. Use the content parameter. This parameter has three properties
1 All: Export/import object definitions and data, the default value of this parameter is all
2) Data_only: Export/import data only.
3) Metadata_only: Only export/import object definitions.

Place multiple dump import statements IMPDP into a batch file, and execute the file.