datapump
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;
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;
0