database:oracle:create-bigfile-tablespace
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| database:oracle:create-bigfile-tablespace [2023/10/08 11:45] – created odefta | database:oracle:create-bigfile-tablespace [2025/01/02 18:22] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 32: | Line 32: | ||
| A bigfile tablespace contains **only one data file** or temp file. This is in contrast to SMALLFILE tablespaces, | A bigfile tablespace contains **only one data file** or temp file. This is in contrast to SMALLFILE tablespaces, | ||
| </ | </ | ||
| + | |||
| + | ===== Create bigfile tablespace for ASM ===== | ||
| + | |||
| + | Replace +DATADISK with your ASM disk: | ||
| + | |||
| + | < | ||
| + | CREATE BIGFILE TABLESPACE DATA | ||
| + | DATAFILE ' | ||
| + | SIZE 100G | ||
| + | AUTOEXTEND ON | ||
| + | NEXT 10G | ||
| + | MAXSIZE 500G | ||
| + | </ | ||
database/oracle/create-bigfile-tablespace.1696765554.txt.gz · Last modified: (external edit)