• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

Importing thru Impdp

I need to refresh my test db and want to use dump file. All the tables are in one schema. Here is my par file that I am using to import. Is there any other parameter that I need to refrence inorder to see a clean Import?
directory=import
dumpfile=abc..dmp
remap_schema=prod:prod
0
bonna
Asked:
bonna
2 Solutions
 
mrjoltcolaCommented:
If you want to guarantee the import is "clean" make sure the schema is empty before import, otherwise your options look fine. WHen I refresh a schema, I usually drop user cascade, then recreate it, prior to import.

0
 
garysadlerCommented:
There are a couple of others you could try:

NETWORK_LINK, along with FLASHBACK_SCN and FLASHBACK_TIME
These allow you to connect to the production database directly and skip the export step.  Not necessary if you're already doing the export step.

TABLE_EXISTS_ACTION
Set it to TRUNCATE to truncate rows in existing tables
Set it to REPLACE to drop and recreate existing tables
Of those two, TRUNCATE is probably the more efficient.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now