Database Administration (MOSC)

MOSC Banner

unexpected ORA-00376: for offline undotbs

edited Dec 11, 2015 10:12AM in Database Administration (MOSC) 7 commentsAnswered

hi

I have a problem on 11.2.0.1 on AIX

undo tablespace already set to UNDOTBS1

undo management is AUTOMATIC

I performed the following steps

CREATE UNDO TABLESPACE undotbs3

ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS3 SCOPE=BOTH;

alter tablespace UNDOTBS1 offline normal;

checked that UNDOTBS1 and its data files were offline

ran a series of very long running insert statements.

All correctly used UNDOTBS3

After all insert statements had completed and been committed the final steps include RENAME TABLE .

at this point there is an error

ORA-00376: file 3 cannot be read at this time

ORA-01110: data file 3: '/NBT6/d001/undotbs01.dbf'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center