| Error while IMP [message #63622] |
Thu, 21 October 2004 05:32  |
sidd
Messages: 130
Registered: May 2003
|
Senior Member |
|
|
IMP-00058: ORACLE error 1562 encountered
ORA-01562: failed to extend rollback segment number 5
ORA-01650: unable to extend rollback segment LARGE_RBS by 2048 in tablespace RBS2
IMP-00028: partial import of previous table rolled back: 1162730 rows rolled back
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Error while IMP [message #63718 is a reply to message #63622] |
Mon, 01 November 2004 00:54  |
Murali
Messages: 54
Registered: December 1999
|
Member |
|
|
When a particular user A has a default tablespace as system, and when that user is backedup (with EXP Utility) and taken as Dump file. Now when this Dump file is Imported into another user B with a different default tablespace TBS_B, it not being imported into User B tablespace TBS_B...but it is getting imported into User A DEFAULT Tablespace i.e, system....even though while specifying FROMUSER and TOUSER Clauses in the IMP Command...!
Pls can u tell me what going on...?
i need a Solution as soon as possible..
thank u.
I am Using : Oracle 9i.
O/S : Windows 2000 professional
E:>IMP AKP/AKP FILE = akp.DMP log = AKP_log.log FROMUSER = AKP TOUSER = AKP
Error msg:
IMP-00009: abnormal end of export file
IMP-00028: partial import of previous table rolled back: 471825 rows rolled back
Regards
Murali
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
