how to export data from database user

[Salvador Reyna]

Hi,

My boss is asking me for extract the data of an user.
I'm making: exp user/passw file=filename.dmp owner=ownername log=logfile.log

But this, export all the schema of this user. How can I export & import the data contents into the tables,...etc.

Thanks a log & Regards.

[Arunvijai_4]

http://www.orafaq.com/faqiexp.htm
[Oracle Import/ Export FAQ]

-Arun

[Salvador Reyna]

thanks a lot.

but, how can i do it ?

[Arunvijai_4]

# exp scott/tiger file=emp.dmp tables=(emp,dept)

(Is it not? )
-Arun

[Jean-Luc Oudart]

Hi

find the full documentation for export/import here :
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm

We may help if you specify in details what you are looking for.

Regards
Jean-Luc

[Salvador Reyna]

thanks a lot