Home » RDBMS Server » Server Utilities » Exporting using query parameter (oracle 10.2.0 , oel 4)
Exporting using query parameter [message #563593] Wed, 15 August 2012 11:34 Go to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
hai to all ;

I am exporting using query parameter. I am trying to export subset of table using rowid.


SQL> select rowid , name from tab1;

ROWID              NAME
------------------ ---------------
AAAM0rAAEAAAAGMAAA sam
AAAM0rAAEAAAAGMAAB sona
AAAM0rAAEAAAAGMAAC rose
AAAM0rAAEAAAAGMAAD chris
AAAM0rAAEAAAAGMAAE san
.................. ....
.................. ....



command given as

exp sam/sam tables=tab1 file=exprwid.dmp query=\"where ROWID='AAAM0rAAEAAAAGMAAA\'\" log=log1.log


Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                           TAB1
EXP-00056: ORACLE error 911 encountered
ORA-00911: invalid character
Export terminated successfully with warnings.



how can i export this record ???

Thanks and Regards
Thiyagusham. G
Re: Exporting using query parameter [message #563594 is a reply to message #563593] Wed, 15 August 2012 11:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>how can i export this record ???
place everything except username/password within Control File to avoid conflict with Command Line Interpreter
Re: Exporting using query parameter [message #563595 is a reply to message #563594] Wed, 15 August 2012 11:47 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ blackswan

Did you mean like this

As sys user :

exp tables=sam.tab1 file=exprwid.dmp query=\"where ROWID='AAAM0rAAEAAAAGMAAA\'\" log=log1.log


About to export specified tables via Conventional Path ...
Current user changed to SAM
. . exporting table                           TAB1
EXP-00056: ORACLE error 911 encountered
ORA-00911: invalid character
Export terminated successfully with warnings.



Regards
Thiyagusham. G
Re: Exporting using query parameter [message #563596 is a reply to message #563595] Wed, 15 August 2012 11:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Did you mean like this
NO

consider Reading The Fine Manual

http://docs.oracle.com/cd/E11882_01/server.112/e22490/ldr_control_file.htm#sthref536
Re: Exporting using query parameter [message #563597 is a reply to message #563595] Wed, 15 August 2012 11:57 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
She means:
exp user/psw parfile=x.par
where x.par contains all options you want without any \.

Otherwise

Regards
Michel
Previous Topic: Getting errors during importing data
Next Topic: split partition in trigger
Goto Forum:
  


Current Time: Thu Mar 28 10:54:26 CDT 2024