unable to make online datafile(ASM environment)
We are working with transportable tablespace to transfer from stage to live. We are asked to implement rollback strategy for this task. We are asked to proceed as follows:
before dropping the target tablespace, we need to keep a copy of the tablespace being dropped at the destination database
so that if any failure occurs during the transfer, we can restore it as it was before dropping at the target.
We are using ORACLE 10g R2 (version 10.2.0.4.0) , ASM environment.
We need to drop a tablespace without dropping the corresponding datafile.
Now, later is it possible to add that datafile to a newly created tablespace so that the contents(database objects) can be available(accessible through SQL for any DML/DDL operations like selecting/altering/updating etc.?)
before dropping the target tablespace, we need to keep a copy of the tablespace being dropped at the destination database
so that if any failure occurs during the transfer, we can restore it as it was before dropping at the target.
We are using ORACLE 10g R2 (version 10.2.0.4.0) , ASM environment.
We need to drop a tablespace without dropping the corresponding datafile.
Now, later is it possible to add that datafile to a newly created tablespace so that the contents(database objects) can be available(accessible through SQL for any DML/DDL operations like selecting/altering/updating etc.?)
0