Dear All,
My databse is 11.2.0.4 on windows 2012 server.
I am trying to take dump of one of my schema with the following command:
C:\>expdp bkpuser/*** schemas=pms2 directory=DUMP_DIR dumpfile=PMS_DLY_DMP.dmp logfile=PMS_DLY_LOG.log
But specifing schema is giving this error:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning option
ORA-39001: invalid argument value
ORA-39071: Value for SCHEMAS is badly formed.
ORA-00942: table or view does not exist
When i query : select username from dba_users where upper(username)='PMS2'; I get PMS2
I have tried both schemas=PMS2 & schemas=pms2
Nothing in the alert log file regarding this error.
I can also connect directory to PMS2 user without any error. If I change the statement to this... It is working
C:\>expdp pms2/**** directory=DUMP_DIR dumpfile=PMS_DLY_DMP.dmp logfile=PMS_DLY_LOG.log -- but the password here confidential and i dont want to use in any of the script file.
User bkpuser only have the limited priveleges to perform export...
Not exactly sure, why this error is there. I have looked at several websites with same syntax.
Kindly help.
Regards, Imran