|
-
It won't automatically be named work1.dbf you would have to do that manually.
alter tablespace work offline;
host cp /u04/Ora06/d_dtafile/work.dbf /u04/Ora06/d_dtafile/work1.dbf
alter database rename datafile '/u04/Ora06/d_dtafile/work.dbf' to '/u04/Ora06/d_dtafile/work1.dbf'
alter tablespace work online;
Once you're sure it's running you should be able to just remove work.dbf
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
|
Reply With Quote