Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Undo tablespace offline issue in 11g

johnfyJul 30 2008 — edited Jul 30 2008

Hi Fellows;

I offline my previous Undo tablespace and created a new online tablespace in 11g. Now when I change a function, procedure or trigger it refers offline tablespace and give following errors
ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3: 'E:\APP\ADMINISTRATOR\ORADATA\DBS\UNDOTBS01.DBF'

Notice :
my old offline tablespace name is UNDOTBS01 on E drive
my current online tablespace name is UNDOTBS02 on C drive

Thank you

Muhammad Imran

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2008

Added on Jul 30 2008

#general-database-discussions

4 comments

1,887 views