ORA-00600: internal error code, arguments: [4194], [4], [31]

wangzhensheng發表於2007-08-11

startup mount ;
select name from v$datafile;
select tablespace_name from dba_tablespaces;

[@more@]

startup mount ;
select name from v$datafile;
select tablespace_name from dba_tablespaces;

alter database datafile '/export/home/oracle/oradata/ECOM/undotbs01.dbf' offline drop;

alter tablespace UNDOTBS1 add datafile '/export/home/oracle/oradata/ECOM/undotbs02.dbf' size 200M;
# create undo tablespace undotbs2 datafile '/export/home/oracle/oradata/ECOM/undotbs02.dbf' size 200m;


ALTER SYSTEM SET undo_tablespace='UNDOTBS1'

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8806316/viewspace-944449/,如需轉載,請註明出處,否則將追究法律責任。

相關文章