That should work (exporting tables from one schema, and importing them
into another) in any version of Oracle. I almost always use a parameter
file for export and import. Here is an example of one that I used to
with an Oracle9 database to export everything for one schema:


userid=rma_owner/[password]@prod
file=H:\export\exp_rma.dmp
log=G:\trace\exp_rma.log
#tables=(vdata)
rows=Y
indexes=Y
constraints=Y
grants=Y
consistent = Y

I saved that as a file named: "exp_rma.ctl", then from a command prompt,
I ran it like this:
exp parfile=exp_rma.ctl


-----Original Message-----
From: Kelly Z. Yi
[mailto:oracledba-ezmlmshield-x75031509.[Email address protected]
Sent: Monday, October 08, 2007 2:54 PM
To: LazyDBA Discussion
Subject: Export data question

I am trying to export data from one schema in production into Test
environment by using schema owner account in the DOS command. There are
some lob data in the table.

When I run exp in the interactive mode the export is hanging up when for
a
specific table? It is not error show. Does anyone know what is going
on?
How to exp data from one schema into another schema by oracle user
account?

my database version is 9i


Thanks,

Kelly Z. Yi


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.



Oracle LazyDBA home page