| Create rollback segment error while importing [message #63756] |
Thu, 04 November 2004 22:44  |
shrikant
Messages: 7
Registered: December 2001
|
Junior Member |
|
|
I have imported full oracle8 database in oracle 9.2 database.
Oracle 9.2 databae is running in automatic undo mode. So while importing it gives me following error that rollback segment can not create. I know rollback segment cann't be created in automatic undo mode. So is it necessary to import rollback segments into new database. Are they contain some data which is not included in remaining dmp file.
|
|
|
|
| Re: Create rollback segment error while importing [message #63771 is a reply to message #63756] |
Fri, 05 November 2004 05:25  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
Befere exporting your ora8 db you should perform a clean shutdown.
If not, som transaction information may still be alocated on rs, so, next startup it will be used to rollback forward.
Exports does not include rs records, only rs segments configuration, that's why your import is trying to recreate them.
If you are sure you performed a clean shutdow, don't care about errors regarding rs creation after importing.
Best luck.
Remote DBA looking for remote job.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
