Hi all,

here's my situation. I am recreating my database. I exported dumps from an 8.1.6 database and imported it into my 9.2.0.3 oracle database. After the import was complete, I copied my datafiles and recreate control files to point to my datafiles location.

I managed to pen it up to mount stage, but when i tried to alter database open i got:

ORA-01092: Oracle instance terminated. Disconnection forced.
and in the alert log i found:
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type

i tried to set my undo_management to MANUAL and startup with the pfile but it doesnt seem to work. the error still persist.

pls help, thanks