riskkasce.blogg.se - Oracle 10g support

#Oracle 10g support drivers#
#Oracle 10g support driver#
#Oracle 10g support manual#
#Oracle 10g support windows#

When the default tablespace type is set to bigfile the BIGFILE keyword is no longer needed in the CREATE TABLESPACE statement, but creation of of a smallfile tablespace requires the SMALLFILE keyword. Once the database is created the ALTER DATABASE command can be used to dynamically alter this setting.ĪLTER DATABASE SET DEFAULT BIGFILE TABLESPACE ĪLTER DATABASE SET DEFAULT SMALLFILE TABLESPACE The default tablespace type is SMALLFILE unless specified otherwise in the CREATE DATABASE command.

The size of the file can be specified in kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T). The first two of the following statements have the same affect as the EXTENT MANAGEMENT LOCAL and SEGMENT SPACE MANAGEMENT AUTO clauses are the default actions, while the last statement would error.ĭATAFILE '/u01/oracle/MYSID/mybigtbs01.dbf' SIZE 100G ĭATAFILE '/u01/oracle/MYSID/mybigtbs01.dbf' SIZE 100G

#Oracle 10g support manual#

Exceptions to this rule include temporary tablespaces, the SYSTEM tablespace and locally managed undo tablespaces which are all allowed to have manual segment-space management.īigfile tablespaces are create using the CREATE BIGFILE TABLESPACE command. Typically bigfile tablespaces must be locally managed with automatic segment-space management.

The ALTER TABLESPACE syntax has been updated to allow operations at the tablespace level, rather than datafile level.

Using fewer larger datafiles allows the DB_FILES and MAXDATAFILES parameters to be reduced, saving SGA and controlfile space.

A bigfile tablespace with 8K and 32K blocks can contain 32 terabyte and 128 terabyte datafiles respectively. By allowing tablespaces to have a single large datafile the totalĬapacity of the database is increased.

An Oracle database can have a maximum of 64,000 datafiles which limits its total capacity.

The benefits of bigfile tablespaces are as follows. In contrast normal (smallfile) tablespaces can have several datafiles, but each is limited in size. Oracle 10g includes improved support for Very Large Databases (VLDBs) including:īigfile tablespaces are tablespaces with a single large datafile.

#Oracle 10g support windows#

Windows (x86), version 7, 8.Home » Articles » 10g » Here Improved VLDB Support in Oracle Database 10g.

Solaris on SPARC, version 8 (Solaris 5.8), 9, 10, 11 and higher.

Solaris x86, version 10 (Solaris 5.10), 11 and higher.

SUSE Linux Enterprise Server Linux 圆4, version 10, 11, 12, 15 and higher.

Ubuntu Linux x86, version 14.04, 16.04, 18.04 and higher (AMD and Intel only).

SUSE Linux Enterprise Server Linux x86, version 10, 11, 12, 15 and higher (AMD and Intel only).

Red Hat Enterprise Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher.

Debian Linux x86, version 7.0, 8.0 and higher (AMD and Intel only).

Linux x86 (32- and 64-bit for AMD and Intel processors.

Oracle Database Cloud Service 18c R1 (18.1).

Oracle Autonomous Transaction Processing Cloud 19c R1 (19.1).

Oracle Autonomous Data Warehouse Cloud 12c R2 (12.2) and higher.

#Oracle 10g support drivers#

(32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.)

#Oracle 10g support driver#

Progress DataDirect for ODBC for Oracle Wire Protocol Driver All 64-bit versions are part of the Connect64 for ODBC Series. Technical Specifications All 32-bit versions of this driver are part of the Connect for ODBC Series.