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.