Med Java

User Tools

Site Tools

Trace:
database:oracle:create-bigfile-tablespace

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
database:oracle:create-bigfile-tablespace [2023/10/08 14:45] – created odeftadatabase:oracle:create-bigfile-tablespace [2023/10/27 21:32] (current) – odefta
Line 32: Line 32:
 A bigfile tablespace contains **only one data file** or temp file. This is in contrast to SMALLFILE tablespaces, which can contain multiple files.  A bigfile tablespace contains **only one data file** or temp file. This is in contrast to SMALLFILE tablespaces, which can contain multiple files. 
 </note> </note>
 +
 +===== Create bigfile tablespace for ASM =====
 +
 +Replace +DATADISK with your ASM disk:
 +
 +<code>
 +CREATE BIGFILE TABLESPACE DATA 
 +DATAFILE '+DATADISK' 
 +SIZE 100G 
 +AUTOEXTEND ON 
 +NEXT 10G 
 +MAXSIZE 500G
 +</code>
  
database/oracle/create-bigfile-tablespace.1696765554.txt.gz · Last modified: 2023/10/08 14:45 by odefta