export of blob object hangs
- From: "Mahadevan, Sundar" <Sundar.Mahadevan@xxxxxxx>
- To: "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Mon, 14 Jun 2010 10:44:34 -0400
Hi All,
Greetings. My source database is 10.2.0.4 on Solaris 10. The destination
database resides on a windows server and is 11.1.0.7. We will be testing our
schema level export generated on the source database (Solaris) to windows. As a
backup I want to have an export generated from my windows desktop with 10.2.0.1
client installed to match the destination windows environment. The database
size is 15GB with system tablespace/temp and redo included. The schema export
on my windows desktop with 10.2.0.1 client ran for more than 50 hours but did
not complete. It hangs at exporting a blob table. The export process did not
die but there is nothing in v$sql_area either. 1) What am I missing here? 2)
Any caveats for Solaris to windows export/import? Many Thanks in advance.
--Sundar
Other related posts:
