Printable View
THE TEAM CREATED A DATAFILE IN THE WRONG TABLESPACE AND IMMEDIATELY
TURNED THE DATAFILE OFFLINE
THE ONLY PROBLEM NOW IS THAT THE SQL BACKTRACK BACKUP IS FAILING BECAUSE THE DATAFILE IS OFFLINE
SHOULD THEY TURN THE DATAFILE BACK ON
AND HOW CAN WE TELL IF THERE IS DATA IN THE DATAFILE??
THANKS FOR YOUR HELP!!
You have a couple of choices here.
1. Bring the file online and resize it to very small size, assuming the file has not been used yet.
2. do 'offline drop' on that file. You won't get the errors but the file entry will remain in dictionary unless you drop and recreate the tablespace.
To check whether any extent exists in datafile you can query DBA_EXTENTS