TABLESPACE NOLOGGING Y GUARANTEE

VALIDAR TABLESPACES

SQL> select tablespace_name,retention from dba_tablespaces;

TABLESPACE_NAME        RETENTION

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

SYSTEM        NOT APPLY

SYSAUX        NOT APPLY

UNDOTBS1        GUARANTEE

TEMP        NOT APPLY

USERS        NOT APPLY

EXAMPLE        NOT APPLY

6 rows selected.

SQL> select tablespace_name,status,logging from dba_tablespaces;

TABLESPACE_NAME        STATUS LOGGING
------------------------------ --------- ---------
SYSTEM        ONLINE LOGGING
SYSAUX        ONLINE LOGGING
UNDOTBS1        ONLINE LOGGING
TEMP        ONLINE NOLOGGING
USERS        ONLINE LOGGING
EXAMPLE        ONLINE NOLOGGING

6 rows selected.

SQL> alter tablespace example logging;

Tablespace altered.

SQL> select tablespace_name,status,logging from dba_tablespaces;

TABLESPACE_NAME        STATUS LOGGING
------------------------------ --------- ---------
SYSTEM        ONLINE LOGGING
SYSAUX        ONLINE LOGGING
UNDOTBS1        ONLINE LOGGING
TEMP        ONLINE NOLOGGING
USERS        ONLINE LOGGING
EXAMPLE        ONLINE LOGGING

6 rows selected.

SQL> alter tablespace example nologging;

Tablespace altered.

SQL> select tablespace_name,status,logging from dba_tablespaces;

TABLESPACE_NAME        STATUS LOGGING
------------------------------ --------- ---------
SYSTEM        ONLINE LOGGING
SYSAUX        ONLINE LOGGING
UNDOTBS1        ONLINE LOGGING
TEMP        ONLINE NOLOGGING
USERS        ONLINE LOGGING
EXAMPLE        ONLINE NOLOGGING

6 rows selected.

SQL> alter tablespace example logging;

Tablespace altered.

VALIDAR TABLAS LOGGING

sql> select owner,table_name,LOGGING from dba_tables where owner='HR'

COLOCAR UNA TABLE EN MODE NOLOGGING

alter table customer nologging;