Home » RDBMS Server » Server Utilities » Stuck up in a table while Importing
Stuck up in a table while Importing [message #202741] Sat, 11 November 2006 10:10 Go to next message
gtcol
Messages: 5
Registered: October 2006
Junior Member

hi all,
i had exported a schema with around 400 tables from a production database yesterday. Today, I am importing the same into a new (test) database server. And when i do that, everything goes fine except that, at a point it stops and don't go any further at all. The table where it stops has got around 2,00,000 thousand records. Could anybody tell me how I can find out why it is not moving any further from that table, as it is not coming up with any error message and is also not logged into bdump file.

This is the import line:
imp user/pword file='path' full=y log=logfileloc;

I am on 9i, 2000 XP Pro and I am using Oracle Import/Export utility.

Thank you for support in advance.
gtcol
Re: Stuck up in a table while Importing [message #202754 is a reply to message #202741] Sat, 11 November 2006 13:59 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If I read it correctly, "2,00,000 thousand records" is 200,000,000 records (two hundred million records). It will take some time to import, that's not a piece of cake.
Re: Stuck up in a table while Importing [message #202755 is a reply to message #202741] Sat, 11 November 2006 14:16 Go to previous messageGo to next message
gtcol
Messages: 5
Registered: October 2006
Junior Member

Sorry, That was 200 thousand records.
But it's not normal to wait for more than an hour. I guess there is some wait event going on in the background. I just can't make it what it would be. Please suggest.
Re: Stuck up in a table while Importing [message #202756 is a reply to message #202755] Sat, 11 November 2006 14:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Set feedback = 1000 on the command line with the import command and this will show you the progression of the import. What type of datatypes are in the "slow" table being imported?
Re: Stuck up in a table while Importing [message #203058 is a reply to message #202741] Mon, 13 November 2006 14:20 Go to previous message
gtcol
Messages: 5
Registered: October 2006
Junior Member

Hi all,
The issue was like this:
The db I was importing into had insuffcient number of redo log files. So while importing, all the redo log files would get filled before they would be archived. So the lgwr would be waiting for a log file to clean up. I added few more redo log file groups. It went fine in the next import.
Thank you all for all your advices.
Previous Topic: Interpreting SQL Loader Load File
Next Topic: IMP-00023 import from 7.3.4 to 8.1.7
Goto Forum:
  


Current Time: Sun Dec 04 14:35:38 CST 2016

Total time taken to generate the page: 0.11093 seconds