| export a single row [message #339461] |
Thu, 07 August 2008 09:47  |
samfuerte
Messages: 7
Registered: May 2008
|
Junior Member |
|
|
Hello,
I'm using this script to exp a single row from a table:
exp userA/A@A file=row.dmp tables=tableA query=\"where code=\'ABC\'\" rows=yes
Does anyone suggest anything?
Here's what I get:
Export: Release 9.2.0.6.0 - Production on Thu Aug 7 16:21:01 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses CL8MSWIN1251 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table tableA
EXP-00056: ORACLE error 911 encountered
ORA-00911: invalid character
Export terminated successfully with warnings.
The reason that I wanna use exp to export the row is that the server (which is identical) where that dmp file will be imported is in another place and the reason I don't send the whole row as an insert is that the row contains a clob value in a column. Also the reason that I don't use dblink is that I don't have access to that server so the only way is to send the dmp file so they can import it.
Thanks in advance
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
