CREATE CONTROLFILE REUSE DATABASE "SID" NORESETLOGS ARCHIVELOG

it will reuse your datafile.

Originally posted by alexandre
I'm recreating control files and i use the command
'alter databse backup controlfile to trace '
the question is, there is no size of the datafile. what will happen if i recreate them without the size of the datafiles;?

Note that all files are there and not damaged.

Regards
Alexandre