For lob data why don't you try SQL Loader .

-----Original Message-----
From: Kelly Z. Yi
[mailto:oracledba-ezmlmshield-x75031509.[Email address protected]
Sent: Tuesday, October 09, 2007 12:24 AM
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

----------------------------------------------------------------------
DISCLAIMER

This email and any files transmitted with it are confidential and are solely for the use of the individual or entity to which it is addressed. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you receive this transmission in error, please notify the sender by reply email and then destroy the message. Opinions, conclusions and other information in this message that do not relate to official business of the company shall be understood to be neither given nor endorsed by NIIT Ltd. or NIIT Technologies Ltd. Any information contained in this email, when addressed to Clients is subject to the terms and conditions in governing client contract.



Oracle LazyDBA home page