Home » RDBMS Server » Server Utilities » Data Pump error ORA-31693 (11GR2)
Data Pump error ORA-31693 [message #539419] Sun, 15 January 2012 07:08 Go to next message
Yud_m
Messages: 6
Registered: January 2012
Location: Israel
Junior Member
Hello

I'm getting the following massage:

ORA-31693: Table data object "033"."EZMILRIKUZ" failed to load/unload and is being skipped due to error:
ORA-00922: missing or invalid option

my backup syntax is:
033/******@INTORCL DIRECTORY=exp_dir DUMPFILE=033.dmp LOGFILE=033.LOG FULL=N REUSE_DUMPFILES=Y FLASHBACK_TIME="TO_TIMESTAMP(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')"

I thought there was a problem with the table so i created a new one and now I'm getting the same error on a different table (the third on in the list:
. . exported "033"."PRQ" 192.9 KB 479 rows
. . exported "033"."EZMIL" 558.8 KB 1229 rows
ORA-31693: Table data object "033"."MIL" failed to load/unload and is being skipped due to error:
ORA-00922: missing or invalid option

when i takeoff the "FLASHBACK_TIME" parameter it works fine.
ButI need this parameter.

Any Suggestions???

Yudit
Re: Data Pump error ORA-31693 [message #539423 is a reply to message #539419] Sun, 15 January 2012 08:29 Go to previous messageGo to next message
Michel Cadot
Messages: 58948
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems an Oracle bug, open a SR.
What is your Oracle version, with 5 decimals?
Post a test case we can reproduce.

Regards
Michel
Re: Data Pump error ORA-31693 [message #539425 is a reply to message #539419] Sun, 15 January 2012 09:17 Go to previous messageGo to next message
John Watson
Messages: 4518
Registered: January 2010
Location: Global Village
Senior Member
This syntax worked for me a couple of weeks ago, on Solaris 2.10:
oracle@mars $ expdp directory=mxout full=y dumpfile=mxout:mxprdfull%U filesize=8g FLASHBACK_TIME=\"TO_TIMESTAMP\(\'28/12/2011 00:15:00\',\'DD/MM/YYYY HH24:MI:SS\'\)\"
Re: Data Pump error ORA-31693 [message #539429 is a reply to message #539425] Sun, 15 January 2012 10:29 Go to previous messageGo to next message
Michel Cadot
Messages: 58948
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here there is a "to_timestamp(to_char(sysdate...)" this is maybe lead to an error in Oracle code...
or maybe the value is not sent to Oracle, the log can show it.

@Yud_m
By the way, you can easily workaround this using FLASHBACK_TIME=SYSTIMESTAMP (without any quote of any kind)

Regards
Michel
Re: Data Pump error ORA-31693 [message #539444 is a reply to message #539429] Mon, 16 January 2012 01:08 Go to previous message
Yud_m
Messages: 6
Registered: January 2012
Location: Israel
Junior Member
Thank You for your Tip, It is much easier to write FLASHBACK_TIME=SYSTIMESTAMP .

The problem seem to be in the database, I created anther table instead of the one that could not be " load/unload"
and drop the old one and it worked Smile

Thank you all for your response


Yudit


Previous Topic: Datapump and index building
Next Topic: Issue while Inserting Multiline Records from a CSV file (2 threads merged by bb)
Goto Forum:
  


Current Time: Mon Sep 01 07:20:42 CDT 2014

Total time taken to generate the page: 0.08901 seconds