Práctica de como borrar tablespace

SQL> connect /as sysdba Connected to an idle instance. SQL> startup ORACLE instance started.

Total System Global Area 234881024 bytes Fixed Size Variable Size Database Buffers Redo BuffersDatabase mounted. Database opened. SQL> select * from v$tablespace 2 ; 1218700 bytes 79693684 bytes 150994944 bytes 2973696 bytes

TS# NAME

INC BIG FLA ENC

---------- --------------------------------- --- --- --0 SYSTEM 1 UNDOTBS1 2 SYSAUX 4 USERS 3 TEMP 6 EXAMPLE 7 EJEMPLO1 YES NO YES YES NO YES YES NO YES YES NO YES NO NO YES YES NO YES YES NO YES

2

8 UNDO_EJEMPLO 9 EJEMPLO2

YES NOYES YES NO YES

9 rows selected.

SQL> desc dba_tablespaces Name Null? Type

----------------------------------------- -------- ---------------------------TABLESPACE_NAME BLOCK_SIZEINITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FORCE_LOGGING EXTENT_MANAGEMENT ALLOCATION_TYPE PLUGGED_IN SEGMENT_SPACE_MANAGEMENT NOT NULL VARCHAR2(30) NOTNULL NUMBER NUMBER NUMBER NOT NULL NUMBER NUMBER NUMBER NUMBER VARCHAR2(9) VARCHAR2(9) VARCHAR2(9) VARCHAR2(3) VARCHAR2(10) VARCHAR2(9) VARCHAR2(3) VARCHAR2(6)

3

DEF_TAB_COMPRESSION RETENTIONBIGFILE

VARCHAR2(8) VARCHAR2(11) VARCHAR2(3)

SQL> select * from dba_data_files;

FILE_NAME -------------------------------------------------------------------------------FILE_ID TABLESPACE_NAMEBYTES BLOCKS STATUS

---------- ------------------------------ ---------- ---------- --------RELATIVE_FNO USER_BLOCKS ------------ --- ---------- ---------- ------------ ---------- ----------ONLINE_------/u01/app/oracle/oradata/admonbd/users01.dbf 4 USERS 4 YES 3.4360E+10 ONLINE 5242880 4194302 640 AVAILABLE 160 5177344 632 AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES

FILE_NAME-------------------------------------------------------------------------------FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS

---------- ------------------------------ ---------- ---------- ---------

4...