RECOVERY OF DAMAGED/DELETED INDEX DATAFILE

OPEN SVRMGR30
CONNECT AS INTERNAL/ORACLE
>STARTUP MOUNT (HERE SEE THAT THE INIT.ORA FILE POINTS TO THE
REQUIRED DATABASE)
>ALTER DATABASE DATAFILE ‘D:\ORANT\DATABASE\INDX2ORDB.ORA’
OFFLINE DROP; --- INDX2ORDB.ORA IS THE CORRUPT DATA FILE.
>ALTER DATABASE OPEN;
THIS WILL OPEN THE DATABASE BUT THEN THE TABLES WHO’S INDEXES
ARE MAPPED IN THE DAMAGED DATAFILE WILL SHOW ERROR SAYING
ORA- : CURRENTLY OFFLINE’

THE ENTIRE INDEX TABLESPACE WILL HAVE TO BE DROPPED AND RECREATED.
BUT >DROP TABLESPACE INDX INCLUDING CONTENTS; WILL GIVE ERRORS ORA-00604, ORA-02429

FOLLOWING STEPS HAS TO BE CARRIED OUT:

(1) INDENTIFY THE USERS WHICH USE THE INDEX TABLESPACE. USING
STORAGE MANAGER=>INDEXES
(2) CREATE USERS EXACTLY LIKE THESE USERS USING CREATE LIKE
OPTION IN SECURITY MANAGER
(3) EXPORT ENTIRE DATABASE USING EXP80 UTILITY
(4) DROP THE ORIGINAL USERS USING SECURITY MANAGER
(5) DROP TABLESPACE INDX INCLUDING CONTENTS
(6) CREATE THE TABLESPACE IN STORAGE MANAGER
(7) IMPORT THE USERS FROM THE DMP FILE CREATED IN STEP 3


I HAVE ONE MORE QUESTION THOUGH, CAN I CONFIGURE THE DATA FILE TO AUTOEXTENT MODE WITHOUT MAKING THE DATAFILE OFFLINE?