Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

exp/imp one single row from/in a table

SamfuerteAug 7 2008 — edited Mar 8 2013

Hello,
I wanna export just one row from a table of one user and import it to the same table on another user. Users are both similar (one is in production other is for testing purposes).
I'm using this for exp:
exp userA/A@A file=row.dmp tables=tableA query=\"where code=\'blah\'\" rows=yes
But I'm getting 911 error:invalid character.
Any idea what's wrong with that?
Also, any idea how the imp will look like?
Thanks in advance

PS: Oracle version is 9.2.0.6.0 and os is win xp.

Problem that I can't use insert select is that users are identical but on different servers (the server where the imp will be is actually in another country :) so I need to send the dmp file. The imp question is only for my personal knowledge update :)

Message was edited by:
Samfuerte

Message was edited by:
Samfuerte