| imp hangs infinitely [message #70948] |
Mon, 19 August 2002 02:23  |
Leo Meyer
Messages: 2
Registered: August 2002
|
Junior Member |
|
|
Hello,
we have a _big_ problem on our W2K Server with Oracle 8.1.7: imp hangs regularly without giving error messages and consumes about 50% CPU resources for days until killed with CTRL-C.
While some of the dmp files are imported ok, others simply won't load.
Somebody has suggested that tablespaces must be set to "non-local autoextend mode", but I don't see a way of changing this. Is there a way to do this or do I have to try to import our 120 GB again? :-((
Unfortunately I don't fully understand all Oracle issues perfectly, but please, if you can, help me with this matter as it is quite urgent. Any help is greatly appreciated.
Greetings,
Leo Meyer
Additional info:
database is in NOARCHIVELOG mode
example parfile:
USERID=ivs/***@p02
FILE=D:p02ftpimportsapdata6expEL40BD_1.dmp
LOG=D:p02ftpimportsapdata6import08082002_112419.log
FROMUSER=SAPR3
TOUSER=IVS
GRANTS=y
INDEXES=y
ROWS=y
CONSTRAINTS=y
|
|
|
|
| Re: imp hangs infinitely [message #70949 is a reply to message #70948] |
Mon, 19 August 2002 03:42  |
K.K. Raj kumar
Messages: 33
Registered: July 2002
|
Member |
|
|
Dear Friend,
In the Parameter above you can add 2 more parameters which will help you in completing the import. Basically Oracle may be just coming to a Freezed state by unable to extend the Rollback segments or unable to 'Commit and reuse the Log files'.
Hence you change the parameter as follows:
example parfile:
USERID=ivs/***@p02
FILE=D:p02ftpimportsapdata6expEL40BD_1.dmp
LOG=D:p02ftpimportsapdata6import08082002_112419.log
FROMUSER=SAPR3
TOUSER=IVS
GRANTS=y
INDEXES=y
ROWS=y
CONSTRAINTS=y
BUFFER=999999
COMMIT=Y
Regards
Raj kumar
|
|
|
|
| Re: imp hangs infinitely [message #70953 is a reply to message #70948] |
Mon, 19 August 2002 06:28 |
Leo Meyer
Messages: 2
Registered: August 2002
|
Junior Member |
|
|
Namaskar Mr Kumar,
many thanks for your reply. I tried it immediately but was not successful.
However, I found out that our dmp-files were incomplete...! Previously I assumed that we had made a mistake... ;-)
Thank you very much again for taking the time to reply.
Regards,
Leo Meyer
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
