| Export error ........... [message #151752] |
Mon, 19 December 2005 00:44  |
cgk_js
Messages: 48
Registered: December 2005
|
Member |
|
|
exp xxxxxx/yyyyyyyy@zzzzzzzz file=test.dmp tables=example query=\"where field3='PM'\"
error is returned as
---------------------
About to export specified tables via Conventional Path ...
. . exporting table EMP
EXP-00056: ORACLE error 904 encountered
ORA-00904: "PM": invalid identifier
Export terminated successfully with warnings.
select * from example where field1 ='PM'
feild1 feild2 feild3 feild4 feild5
---------- ----------------------- -----------------
Smith 4 PM 25000 8
|
|
|
|
| Re: Export error ........... [message #151787 is a reply to message #151752] |
Mon, 19 December 2005 04:26  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
Hi,
Can u try:
exp xxxxxx/yyyyyyyy@zzzzzzzz file=test.dmp tables=example query=\"where field3='\PM\'\"
(-just escape the single quote as well)..if still it does not work then pl. post back the error: also can u export the table , if you omit the query?
N.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
