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
… [Trackback]
[…] Here you can find 7329 additional Info to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Info on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Read More on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Read More on to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Here you will find 65304 additional Info on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Read More on on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Info on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Read More to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Find More here to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Read More on on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Here you can find 37029 additional Info on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Read More here on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] There you can find 34884 more Information on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Info on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Read More on on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Read More Info here on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Info on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Find More on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Find More Information here on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Find More here to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Here you can find 75399 additional Info on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Find More on to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Find More on on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] There you can find 16853 additional Information to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Information to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Info on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Find More Info here on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Find More to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Here you can find 92519 more Information on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Info to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Find More Information here on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Information to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Find More to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] There you will find 75502 additional Information to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Read More Info here to that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]
… [Trackback]
[…] Read More on on that Topic: techdatabasket.com/2015/10/03/configuring-an-oracle-database-11g-to-use-bigfile-tablespace/ […]