-
move a read only Tablespace
Hi,
I want to copy a read-only tablespace to another location and the tomorrow to rename it via the database ant remove the old location.
will this work?
Today:
OS>cp all_data_files_tbs_read_only to_another_location
Tomorrow:
SQL> Alter tablespace tbs_read_only offline;
SQL> Alter database rename datafile to to_another_location;
SQL> Alter tablespace read write;
OS>rm old all_data_files_tbs_read_only
Bensmail
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
|