| Stuck up in a table while Importing [message #202741] |
Sat, 11 November 2006 10:10  |
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 #203058 is a reply to message #202741] |
Mon, 13 November 2006 14:20  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
