Importing a dmp with partitioned tables into Oracle XE

1. Import the schema using normal commands and verify the logs

impdp userid=scott56 schemas=scott56 directory=DB_DUMP dumpfile=scott56_dump_backup.dmp

2. Generate the sqlfile using SQLFILE option with impdp

impdp userid=scott56 directory=DB_DUMP dumpfile=scott56_dump_backup.dmp SQLFILE=scott56.sql

3. Find the partition table from generated sql file
Convert partition table to non-partition table and create those table in schema

3. Import the CONTENT=DATA_ONLY option using impdp

impdp userid=scott56 TABLES=TBLMCONCURRENTUSERS  CONTENT=DATA_ONLY directory=DB_DUMP dumpfile=scott56_dump_backup.dmp

Oracle 11g onwards supports exporting tables by merging partitions in EXPDP. Please refer to the option of PARTITION_OPTIONS when exporting using the expdp utility.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.