Migrate/upgrade to 9i from 8i using export/import

[newbie]

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

[jmodic]

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.

[adewri]

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 ?

[jmodic]

Originally posted by adewri
I think u meant Locally Managed... right ?

Yes, of course. My mistake.