-
Hello all, I've created a brand-new 9i db with identical dbname and file-structure(mount points) but when I do an import using my export from 8i with full=y option I've got a bunch of these errors:
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITIAL 1048576 NEXT 1048576 M"
"INEXTENTS 20 MAXEXTENTS 505) TABLESPACE "RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
and these:
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
Are these okay? Thanks
-
Originally posted by newbie
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE PUBLIC ROLLBACK SEGMENT RBS13 STORAGE(INITIAL 1048576 NEXT 1048576 M"
"INEXTENTS 20 MAXEXTENTS 505) TABLESPACE "RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
You can more or less ignore this errors - you obviously have set up your database for automatic undo mode, so rollback sefments from export are not relevant for you.
and these:
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
Those errors are much more to be worried about. I'm allmost certain your tablespaces from dmp file were not created in your 9.2 database during the import. It's obvious that your system tablespace in 9.2 database was created as localy managed tablespace during database creation (this is the default behavior). I'ts also obvious that tablespaces in your 8i database were created as dictionary managed tablespaces. The problem in 9.2 is that if your system TS is localy managed then no other tablespace can be dictionary managed. So "CREATE TABLESPACE ... EXTENT MANAGEMENT DICTIONARY " commands from your dmp are failing because DMT tablespaces are not allowed with LMT system tablespace.
So you basicaly have two options:
a) create your 9.2 database again, this time with dictionary managed system tablespace (I wouldn't go for this option).
b) manualy create the tablespaces that you had in your 8i database, only that in 9.2 they will be dictionary managed.
If you'll go for option b), then don't forget to use DESTROY=N (the default) when you import.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Originally posted by jmodic
b) manualy create the tablespaces that you had in your 8i database, only that in 9.2 they will be dictionary managed.
I think u meant Locally Managed... right ?
Amar
"There is a difference between knowing the path and walking the path."
-
Originally posted by adewri
I think u meant Locally Managed... right ?
Yes, of course. My mistake.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|