Re: export of blob object hangs
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: Sundar.Mahadevan@xxxxxxx
- Date: Mon, 14 Jun 2010 22:13:13 +0530
Hi,
If you are using data pump, importing a blob will hang and need to follow a
different method.
http://www.oracle-base.com/articles/8i/ImportBlob.php
-An
On Mon, Jun 14, 2010 at 8:14 PM, Mahadevan, Sundar <Sundar.Mahadevan@xxxxxxx
> wrote:
> 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:
