ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [5396], [2242], [], [], [],[], []
rename spfile , startup from pfile
shut immediate
startup
CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE 'F:\NBSD1112\UNDOTBS03.ORA' SIZE 500M REUSE AUTOEXTEND ON;
ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS2;
shut immediate
change undo_tablespace=UNDOTBS2 into parameter file
startup
DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE 'F:\NBSD1112\UNDOTBS01.ORA' SIZE 500M REUSE AUTOEXTEND ON;
ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS1;
shut immediate
change undo_tablespace=UNDOTBS1 into parameter file
startup
DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES;
No comments:
Post a Comment