OraFAQ Forum: Server Utilities » Exporting using query parameter

Home » RDBMS Server » Server Utilities » Exporting using query parameter (oracle 10.2.0 , oel 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exporting using query parameter [message #563593]

Wed, 15 August 2012 11:34

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

Report message to a moderator

Re: Exporting using query parameter [message #563594 is a reply to message #563593]

Wed, 15 August 2012 11:37

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

Report message to a moderator

Re: Exporting using query parameter [message #563595 is a reply to message #563594]

Wed, 15 August 2012 11:47

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

Report message to a moderator

Re: Exporting using query parameter [message #563596 is a reply to message #563595]

Wed, 15 August 2012 11:52

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

Report message to a moderator

Re: Exporting using query parameter [message #563597 is a reply to message #563595]

Wed, 15 August 2012 11:57

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Getting errors during importing data
Next Topic:	split partition in trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 18:54:35 CST 2025