Database Utilities (MOSC)

MOSC Banner

10g impdp - problem with directory parameter

edited Jan 29, 2010 7:34PM in Database Utilities (MOSC) 24 commentsAnswered
 I'm running a 10g DB and for the first time I got a dump from a customer that was generated by expdp. I looked up some example in the web under
http://www.oracle.com/technology/obe/obe10gdb/storage/datapump/datapump.htm
and typed in the example at the bottom of that page. Got some syntax error and that the datadir was missing or something.
Then I followed the steps at the top of that page: 

		
				CREATE DIRECTORY datadir1 AS '/import/mydatabase';
					
					
CREATE DIRECTORY datadir2 AS '/import/mydatabase';
and
	
		GRANT READ,WRITE ON DIRECTORY datadir1 TO sh;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center