Oracle Database Discussions

Hi,

I need to take data pump export of a database of the size 320 GB, I want to exclude the indexes during the export, the Index Tablespace size is around 60 GB, if I exclude the indexes then the probable size of the export dump will be much lesser than with the Indexes. My intention is to export the full database and import it to the new database, during the export I want to exclude the indexes and then create it on the new database later.

Please verify my procedure of export and import.

Export:

*expdp system full=y directory=test_dir dumpfile=full_expdp%U.dmp logfile=full_expdp.log PARALLEL=3 JOB_NAME=fullexport FILESIZE=50G EXCLUDE=INDEX*

with the above command I will exclude the index and then I will import it into another database with the import command as follows;

impdp system full=y DIRECTORY=test_dir DUMPFILE=full_expdp%U.dmp... LOGFILE=fullimp.log TABLE_EXISTS_ACTION=APPEND

To create the indexes on the new database I will export the Index's metadata only then import it on the new database;

*expdp system full=y directory=TEST_DIR dumpfile=full_index.dmp logfile=exp_index.log CONTENT=METADATA_ONLY include=index*

the above command will export the Index metadata only and nothing else, correct me if I am wrong.

then I will import this dump file into the new database with the below import command;

impdp system full=y DIRECTORY=test_dir DUMPFILE=full_index.dmp LOGFILE=imp_index.log

this will create the Index metadata on the newly imported database, then I need to create the indexes on the new database.

ALTER INDEX name REBUILD...;

Please correct me if I am wrong at any point.

Any feedback will be higly appreciated!