expdp query [message #552178] |
Tue, 24 April 2012 03:06 |
|
lerry
Messages: 16 Registered: December 2011
|
Junior Member |
|
|
hi:
expdp test/test directory=dmpdir dumpfile=wip.dmp logfile=wip.log tables=wip_runcard query=wip_runcard:'"where org_id=51 and time<to_date ('2011-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') and ship_time is not null and wip_route=999 and used_status=5"'
but error:
ORA-31693: Table data object "TEST"."WIP_RUNCARD" failed to load/unload and is being skipped due to error:
ORA-00907: missing right parenthesis
how to use expdp query paramter with time??
|
|
|
|
|
|
|
|
Re: expdp query [message #552197 is a reply to message #552194] |
Tue, 24 April 2012 04:48 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Actually, I think Michel's method would probably be better: escaping all the awkward characters is very Unix specific, I think one would have to sort out the quotes properly for Windows.
But thanks for providing the solution.
|
|
|