-
Is there anyway we can move datafiles from 1 TS to another TS. If so, how can this be done? Thanks
-
Depends on what you want to do. If you want to move the datafiles containing the data, then no, it can't be done. If you just want to reuse a datafile from an old tablespace, then yes. Say datafile /u01/oradata/xyz/xyz01.dbf is part of the xyz tablespace.
alter tablespace xyz offline;
drop tablespace xyz;
create tablespace abc datafile '/u01/oradata/xyz/xyz01.dbf' reuse;
Jeff Hunter
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
|