Problem with data pump : ORA-39002: invalid operation


I want to do an export with the data pump :

expdp ogtest/ogtest@devseam DIRECTORY=dpump_ogtest DUMPFILE=expfull_ogtest.dmp FULL=y NOLOGFILE=y

Export: Release 10.2.0.3.0 – Production on Monday, 03 March, 2008 13:25:39 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Production With the Partitioning, OLAP and Data Mining options ORA-39002: invalid operation

ORA-39070: Unable to open the log file.

ORA-29283: invalid file operation

ORA-06512: at “SYS.UTL_FILE”, line 475

ORA-29283: invalid file operation
Sometimes I get the error: error 13: persmission denied…

the solution is :

on host :

# mkdir /usr/dpump_ogtest
# chown -R oracle:dba /usr/dpump_ogtest
# chown -R 775 /usr/dpump_ogtest
on sqlplus :
# cd $ORACLE_HOME/bin
# ./sqlplus sys/oracle@XE as sysdba;
sql> CREATE DIRECTORY dpump_ogtestAS '/usr/dpump_ogtest';
sql> grant exp_full_database to ogtest;
sql> grant read, write on directory dpump_ogtest to ogtest;
sql>exit
# cd $ORACLE_HOME/bin
# ./expdp ogtest/ogtest@devseam DIRECTORY=dpump_ogtest DUMPFILE=expfull_ogtest.dmp FULL=y NOLOGFILE=y


........
........
. . exported "SYSTEM"."REPCAT$_TEMPLATE_PARMS"               0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS"           0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES"               0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS"             0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS"          0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES"             0 KB       0 rows
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"              0 KB       0 rows
. . exported "TSMSYS"."SRS$"                                 0 KB       0 rows
Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
  /source/backupdata/sys_schema.dmp
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at 11:32:29
Advertisements

One thought on “Problem with data pump : ORA-39002: invalid operation

  1. I am genuinely grateful to the owner of this website who has
    shared this wonderful piece of writing at at this time.

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 )

w

Connecting to %s