i have a user datafile of size 145mb in personal oracle. i have changed my system and loaded personal oracle once again.
now from my backup drive i want to add this datafile to the new database. how can i do this??
how to change the controlfile to have an entry for the new datafile??
If u're using oracle 8i personal edition, it can be done via export
with transportable tablespace option, then copy the datafile to ur
source database and then import it dump file into the database.
while importing, it wil make an entry into the data dictionary.
This works fine, only if the former database has the same
configuration of the later database.
AS PANDO SAID U NEED TO RESTORE ALL SYSTEM DATAFILES,USER,TEMP,RBS ,INDX I.E,ALL DATAFILES
WHICH IS IN DATABASE FOLDER IN ORACLE HOME.
THEN YOUR CONTROLFILES OF THAT TIME,REDOLOGFILES ALL HAS TO BE RESTORED ALSO.TRY IT AND SEE.