Create a folder for importing an Oracle dump file

Generally speaking, in Oracle DB, for you to be able to import a dump file, you have to use a predefined list of directories in order to read the dump file from, don’t know why, but that’s how it goes. I had a 60 GB dump file on an external HDD and it wasn’t an option to copy that file locally.

Since I needed to import from that file while it’s on that HDD, I had to add that directory to the database via this SQL command:

CREATE DIRECTORY datapump AS ‘E:\user\datafile\datapump’;

Where “E” is the hard drive partition.

That’s it!

I restarted toad, and it was able to read the new directory and the importing process is in progress now.

Advertisements

About SoCRaT

Software Engineer, OSS & Linux Geek
This entry was posted in Uncategorized and tagged , , , , . Bookmark the permalink.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s