Quote:
Originally posted by YellowLark
Reading your posts, where you mention "recreate" and not having a backup file, I'm wondering if you are trying to recover your data, not just to allocate a new datafile.
If you are trying to get that data back, you may be out of luck without any backup available.
Recreating is different from restoring.. Recreating is done when no backup is available and all the archivelogs are available from the time of datafile creation. Restoration is only possible with backup sets available.. Recovery is possibly only when back up of datafiles and archivelogs are available :p