1 Reply Latest reply on Apr 11, 2013 10:24 PM by user6445925

    7.3.4 to 8.1.7  ODMA ERROR : ORA-01552: CANNOT USE SYSTEM ROLLBACK

      Trying to upgrade an old 7.3.4 database running on Aix to 8.1.7 so I can get a compatible export file to allow me to take it to 10gR2.
      I have done some work to get the init.ora file configured with the proper values but the odma fails with the following error:
      drop table dual;
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01552: cannot use system rollback segment for non-system tablespace 'xxx'

      I have other rollback segments defined by my init.ora file and during a normal database startup they are online.
      When I run the 'odma' process it takes the database down and when it brings it up it only has the SYSTEM rollback segment online.

      I know this is an old configuration but anyone have any suggestions?
      I do have "audit_trail = none" in my init file.

      Looks like to just do an exp/imp I don't need to worry about going through odma so I am just going to close this post.

      Edited by: user6445925 on 11-Apr-2013 15:23