Recover a Dropped Tablespace Using TSPITR
Testato su Oracle 12c. Cancellare un tablespace di un pluggable database e recuperarlo. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 S12AVA1 READ WRITE NO 4 S12AVA1_CLONE READ WRITE NO SQL> alter session set container=s12ava1; Session altered. SQL> create tablespace tbs_dc datafile '/u01/app/oracle/oradata/CDB12S01/s12ava1/tbs_dc0101' size 500M autoextend on next 50 M maxsize 1024M extent management local autoallocate blocksize 8k segment space management auto; / Tablespace created. SQL> create user bruce identified by bruce default tablespace tbs_dc account unlock temporary tablespace temp quota unlimited on tbs_dc profile default; User created. SQL> grant connect to bruce; Grant succeeded. SQL> alter s