Modificarea tablespace-ului TEMP și UNDO în Bigfile tablespaces

Un Bigfile tablespace  (BFT) este un tablespace care conține un singur fișier care poate avea o dimensiune foarte mare. Unul din beneficiile Bigfile tablespace este simplificarea managementului prin reducerea numărului de fișiere. 

create bigfile undo tablespace UNDOTBS2
DATAFILE ‘+DATA_DG’ size 100M autoextend on next 100m maxsize 200G;

create bigfile temporary tablespace TEMP1 tempfile ‘+DATA_DG’
size 10G autoextend on next 1G maxsize 200G;

alter database default temporary tablespace TEMP1;
alter system set undo_tablespace=UNDOTBS2 scope=both;

drop tablespace UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;
drop tablespace TEMP INCLUDING CONTENTS AND DATAFILES;

SQL> select FILE_NAME, TABLESPACE_NAME,MAXBYTES/1024/1024/1024 from dba_temp_files;

FILE_NAME                        TABLESPACE_NAME                MAXBYTES/1024/1024/1024
––––––––––––––––––––––––––––––––––––– ––––––––
+DATA_DG/orcl/tempfile/temp1.282.880021001        TEMP1                                              200

SQL> select FILE_NAME,TABLESPACE_NAME,MAXBYTES/1024/1024/1024 from dba_data_files;

FILE_NAME                            TABLESPACE_NAME                MAXBYTES/1024/1024/1024
––––––––––––––––––––––––––––––––––––– ––––––––
+DATA_DG/orcl/datafile/system.280.879602311            SYSTEM                                      31.9999847

+DATA_DG/orcl/datafile/sysaux.281.879602313            SYSAUX                                      31.9999847

+DATA_DG/orcl/datafile/undotbs1.282.879602315            UNDOTBS1                                           200

+DATA_DG/orcl/datafile/users.284.879602323            USERS                                       31.9999847