OraFAQ Forum: Server Utilities » Data Pump error ORA-31693

Home » RDBMS Server » Server Utilities » Data Pump error ORA-31693 (11GR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data Pump error ORA-31693 [message #539419]

Sun, 15 January 2012 07:08

Yud_m
Messages: 14
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

Report message to a moderator

Re: Data Pump error ORA-31693 [message #539423 is a reply to message #539419]

Sun, 15 January 2012 08:29

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Data Pump error ORA-31693 [message #539425 is a reply to message #539419]

Sun, 15 January 2012 09:17

John Watson
Messages: 8962
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\'\)\"

Report message to a moderator

Re: Data Pump error ORA-31693 [message #539429 is a reply to message #539425]

Sun, 15 January 2012 10:29

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Data Pump error ORA-31693 [message #539444 is a reply to message #539429]

Mon, 16 January 2012 01:08

Yud_m
Messages: 14
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 07:09:47 CST 2024