Migrate/upgrade to 9i from 8i using export/import - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

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

  1. #11
    Join Date
    Mar 2001
    Posts
    149
    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

  2. #12
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  3. #13
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  4. #14
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
  •  


Click Here to Expand Forum to Full Width