Unix Technical Forum

Import hangs with 12801 oracle 8174

This is a discussion on Import hangs with 12801 oracle 8174 within the Oracle Database forums, part of the Database Server Software category; --> After trying to import an entire schema fromuser touser the import which was more then 50% hang with IMP00017 ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-24-2008, 01:01 PM
Teresa
 
Posts: n/a
Default Import hangs with 12801 oracle 8174

After trying to import an entire schema fromuser touser the import
which was more then 50% hang with IMP00017 IMP 12801, there was not
other message, I dont know what was causing this, then I killed it and
did the rest of the tables manually. This is for solaris 5.8 and
oracle 8.1.7.4

Can someone please help
Thanks
Teresa
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-24-2008, 01:01 PM
Koki Sarmiento
 
Posts: n/a
Default Re: Import hangs with 12801 oracle 8174


Teresa wrote:
> After trying to import an entire schema fromuser touser the import
> which was more then 50% hang with IMP00017 IMP 12801, there was not
> other message, I dont know what was causing this, then I killed it

and
> did the rest of the tables manually. This is for solaris 5.8 and
> oracle 8.1.7.4
>
> Can someone please help
> Thanks
> Teresa


Looks like bug:1548982
This problem is introduced in 8.1.7.3 though.

Maybe you didn't install patch set 8.1.7.4 correctly. try running
catalog.sql and catproc.sql again.

You can also workaround the poblem by specifiying indexes=n in your
import command and then run script to create indexes manually, until
you find a permanent solution.

Hope this helps.

Best Regards,
Koki

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:59 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com