Primer Brisanje Tablespace TBS_02

Table of Contents

Kreiranje tablespace Tbs_02

Oracle Version 19.20 on Linux

SQL> conn sys@pdb1/SysPassword1 as SYSDBA

SQL> CREATE TABLESPACE Tbs_02;

SQL> SELECT UT.TABLESPACE_NAME "TABLESPACE", COUNT (US.SEGMENT_NAME) "NUM SEGMENTS"

FROM DBA_TABLESPACES UT, DBA_SEGMENTS US

WHERE UT.TABLESPACE_NAME = US.TABLESPACE_NAME(+)

and UT.tablespace_name like 'TBS_02'

GROUP BY (UT.TABLESPACE_NAME) ORDER BY 1;

TABLESPACE,NUM SEGMENTS

TBS_02,0

Zakljucak: tablespace je prazan, zadovoljen uslov za brisanje

SQL> DROP TABLESPACE TBS_02 INCLUDING CONTENTS AND DATAFILES

Alert.log

2023-09-19T16:40:02.780533+02:00

PDB1(3):Deleted Oracle managed file /u02/oradata/CDB1/030C3731964504ADE0635802020A1C1E/datafile/o1_mf_tbs_02_ljm8pfgt_.dbf

PDB1(3):Completed: DROP TABLESPACE TBS_02 INCLUDING CONTENTS AND DATAFILES