Home » RDBMS Server » Server Utilities » export a single row (Oracle, 9.2.0.6.0, winXP)
export a single row [message #339461] Thu, 07 August 2008 09:47 Go to next message
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
Re: export a single row [message #339470 is a reply to message #339461] Thu, 07 August 2008 10:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses CL8MSWIN1251 character set (possible charset conversion)

Are these character sets compatible?

Regards
Michel
Re: export a single row [message #339474 is a reply to message #339461] Thu, 07 August 2008 10:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Mostly it has to do with the escape characters you are using.
Specific OS will need specific escape characters.
Instead of
query=\"where code=\'ABC\'\"

try
 query=\"where code='ABC'\" 

If above will not work, try other escape patterns.


Re: export a single row [message #339687 is a reply to message #339474] Fri, 08 August 2008 02:25 Go to previous message
samfuerte
Messages: 7
Registered: May 2008
Junior Member

Thnx, actually the 2nd solution worked. I didn't know that had to do with OS Smile
Previous Topic: Problems when running SQL Loader with a sequence and the option direct=true
Next Topic: IMP
Goto Forum:
  


Current Time: Tue Dec 06 04:41:43 CST 2016

Total time taken to generate the page: 0.09269 seconds