Data Pump Import

For the last few years that I have been work as a DBA here, I have always used imp and exp to import and export data to the databases.
But with our recent increased used of 10g databases I have started to use impdp and expdp.

I felt that it would be better to use these versions rather that the outdated(?) versions. But the new syntax takes a little getting used to. But then again it took me a little while to be able to type and imp/dmp command without have to look it up or use an excel cheat sheet.

EDIT : Of course the impdp/expdp are also more powerfull, allowing for schema and tablespace remapping during the import.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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