Configurando um banco de dados Oracle 11g para usar Bigfile Tablespace

October 3, 2015 brunors

 

Para configurar um banco de dados para usar Bigfile Tablespace  (tipo de tablespace que usa um único datafile chamado bigfile <> smalffile (padrão)) e somente é “locally managed tablespace with automatic segment space management”, você deve seguir os seguintes passos:

—   Configure o banco de dados para usar  BIGFILE TABLESPACE

ALTER DATABASE SET DEFAULT BIGFILE TABLESPACE;

— Verificaro o tipo de tablespace padrão no banco de dados:

SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME = ‘DEFAULT_TBS_TYPE’;

—  Exemplo para criar uma Bigfile Tablespace:

CREATE BIGFILE TABLESPACE BIGTECHDATABASKET
DATAFILE ‘/u01/app/oracle/oradata/bigtechdatabasket.dbf’ SIZE 100G;

Referências:

Oracle®  Database Administrator’s Guide 14 Managing Tablespaces
Oracle®  Database Administrator’s Guide 2 Creating and Configuring an Oracle Database

brunors

Related posts

• August 16, 2023 brunors 0

  Oracle Database Growth Monitoring Script

  The Oracle Database Growth Monitoring Script is a tool designed to track and analyze the growth...
• May 29, 2023 brunors 0

  PL/SQL package SYS.DBMS_BACKUP_RESTORE version is not currentPL/SQL package SYS.DBMS_RCVMAN version 19.10.00.00 is too old

  Recently, I undertook the task of upgrading an Oracle database from version 19.10 to 19.18. As...
• May 29, 2023 brunors 0

  Enable online status for all Oracle database datafiles

  I have executed a database migration by transitioning from a physical active data guard to a...