Actualizaciones a Tablespace y Datafile

Actualizaciones a Tablespace y Datafile 

ADD DATAFILE
ALTER TABLESPACE TBS_IIIII2007_DAT01 ADD DATAFILE
   'C:\DATABASES\DB01\DATAFILES\TBS_IIIII2007_DAT01_FILE02.DBF' SIZE 10M;

DROP DATAFILE
ALTER TABLESPACE TBS_IIIII2007_DAT01 DROP DATAFILE
   'C:\DATABASES\DB01\DATAFILES\TBS_IIIII2007_DAT01_FILE02.DBF';
ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/users03.dbf'     AUTOEXTEND OFF;

CONSULTA LOS DATA FILES
SELECT * FROM DBA_DATA_FILES ;

MOVIENDO UN TABLESPACE
alter table table_name move tablespace users;

UN ERROR COMÚN
-- ORA-01652: unable to extend temp segment by 128 in tablespace TBS_01

BORRANDO UN TABLESPACE
DROP TABLESPACE TBS_01
   INCLUDING CONTENTS AND DATAFILES;

CREANDO UN TABLESPACE
 CREATE TABLESPACE TBS_01
 DATAFILE       '/u0......../TBS_01.DBF'  SIZE 20M,
                '/u0......./TBS_02.DBF' SIZE 20M
 EXTENT MANAGEMENT LOCAL
 SEGMENT SPACE MANAGEMENT AUTO;

MODIFICANDO UN TABLESPACE OPCIONES
ALTER DATABASE DATAFILE '/u0....../TBS_02.DBF'  RESIZE 200M;

ALTER TABLESPACE TBS_CB_CVP ADD DATAFILE '/u0....../TBS_03.DBF'  SIZE 50M;

ALTER TABLESPACE users
    ADD DATAFILE '/u0x/.../users03.dbf' SIZE 10M
      AUTOEXTEND ON
      NEXT 512K
      MAXSIZE 250M;

INCREMENTO EN AUTOMÁTICO
ALTER DATABASE DATAFILE '/u0..../TBS_CB_CVP_06.DBF' AUTOEXTEND ON;
alter table table_name move tablespace users;

UN ERROR COMÚN
-- ORA-01652: unable to extend temp segment by 128 in tablespace TBS_01

BORRANDO UN TABLESPACE
DROP TABLESPACE TBS_01
   INCLUDING CONTENTS AND DATAFILES;

CREANDO UN TABLESPACE
 CREATE TABLESPACE TBS_01
 DATAFILE       '/u0......../TBS_01.DBF'  SIZE 20M,
                '/u0......./TBS_02.DBF' SIZE 20M
 EXTENT MANAGEMENT LOCAL
 SEGMENT SPACE MANAGEMENT AUTO;

MODIFICANDO UN TABLESPACE OPCIONES
ALTER DATABASE DATAFILE '/u0....../TBS_02.DBF'  RESIZE 200M;
ALTER TABLESPACE TBS_CB_CVP ADD DATAFILE '/u0....../TBS_03.DBF'  SIZE 50M;
ALTER TABLESPACE users
    ADD DATAFILE '/u0X/... /users03.dbf' SIZE 10M
      AUTOEXTEND ON
      NEXT 512K
      MAXSIZE 250M;

INCREMENTO EN AUTOMÁTICO
ALTER DATABASE DATAFILE '/u0..../TBS_CVP.DBF' AUTOEXTEND ON;