-
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
In god i trust
-
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
-
You never mention size for controlfile. Thats system generated file(Oracle internal specfic) which has the information of all the files associated with the database.
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|