bigfile tablespace - cheeyoung/sqlplus-public GitHub Wiki
| block size | |||
|---|---|---|---|
| 32K (32768) | 12MB | 128TB | |
| 8K (8192) | 7MB | 32TB | |
| 4K (4096) | |||
| 2K (2048) |
| file(s) per ts |
blocks per file |
block# | |
|---|---|---|---|
| bigfile | 1 | 232 | |
| smallfile | 1022 | 222 | 0, 1 to 4,194,303 |
- ORA-1144: File size (%s blocks) exceeds maximum of 4194303 blocks
ORA-01144: File size (string blocks) exceeds maximum of string blocks
CREATE TABLESPACE (Oracle Database Release 21)