Database Utilities (MOSC)

MOSC Banner

datapump

edited Nov 14, 2011 2:53AM in Database Utilities (MOSC) 5 comments
Hi, I'm using Oracle 10.2.0.4 on Redhat linux 5 64bit.

I'm trying to export a database:

 expdp full=y userid=system/pword_here directory=EXPORT_DIR dumpfile=expMon.dmp logfile=expMon.log

but nothing happens.

Datapump just sits there.  It creates the files but nothing happens.  I've let it sit for hours but nothing happens.


$ ls -ltr
total 4
-rw-r--r-- 1 svc_oracle dba    0 Nov  7 22:59 expMon.log
-rw-r----- 1 svc_oracle dba 4096 Nov  7 22:59 expMon.dmp

So I know the files are getting created.


I granted the following privs:

SQL> grant read,write on directory export_dir to system;

Grant succeeded.

SQL> grant dba to system;

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