expdp query [message #552178] |
Tue, 24 April 2012 03:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/e5975dcc620c2df03efb06de13170c6c?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8937 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.
|
|
|