|
-
other way round
1. alter database backup controlfile to trace.
2. shutdown immediate or normal.
3. edit the create controlfile control file sript
4. startup nomount
5. recreate the control files.
6. alter database open noresetlogs
7. alter tablespace temp add tempfile 'absolute path' size 500M;
HTH
Amar
"There is a difference between knowing the path and walking the path."

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
|