Export (EXPDP ) Error : ORA-31633,ORA-01950,ORA-29283,ORA-29283

Perform export/import operation using datapump

then imp_full_database/exp_full_database privilege are required



[oracle@localhost ~]$ expdp import/export directory=datapump dumpfile=orcl.dmp logfile=orcl.log



Export: Release 10.2.0.1.0 - Production on Saturday, 13 April, 2013 13:03:51

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31633: unable to create master table "IMPORT.SYS_EXPORT_SCHEMA_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 863
ORA-01950: no privileges on tablespace 'USERS'



this error is resolved by


alter user import quota unlimited on users;


means to give the quota to user on users tablespace.


with datapump export

Export: Release 10.2.0.1.0 - Production on Monday, 15 April, 2013 14:03:24

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.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


to check the permission on folder

because the expdp utility not perform write operation on directory