Snippet Name: TABLESPACE: Using Raw Devices
Description: A raw device is a portion of a physical disk that Oracle uses for its database files. Raw devices are not like regular file management systems. The information they store cannot be identified or accessed by users.
A raw device is created when an extended partition is created and logical partitions are assigned to it without applying any formatting.
You can partition a raw device to store data and control files, and also use the entire raw device to store data.
Also see:
» TABLESPACE: Show contiguous space
» TABLESPACE: SYSAUX tablespace
» TABLESPACE: Tablespace management
» TABLESPACE: List tablespaces, files, ...
» TABLESPACE: Dropping Tablespaces
» TABLESPACE: Alter Permanent Tablespace
» TABLESPACE: Transportable tablespaces
» TABLESPACE: Tempfile operations
» TABLESPACE: Create temp tablespace
» TABLESPACE: Change UNDO tablespace
» TABLESPACE: Undo Tablespace
» TABLESPACE: SYSAUX Tablespace
» TABLESPACE: Set default tablespace type
» TABLESPACE: Oracle Managed Auto-extend...
» TABLESPACE: Permanent Tablespace Using...
» TABLESPACE: Using Raw Devices
» TABLESPACE: permanent tablespace
» RAWTONHEX
» RAWTOHEX
» HEXTORAW
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 12th, 2009
|
-- syntax:
CREATE TABLESPACE <tablespace_name>
DATAFILE '<path_and_file_name>'
SIZE <integer><K | M | G | T>
BLOCKSIZE <bytes>
AUTOEXTEND OFF
EXTENT MANAGEMENT UNIFORM LOCAL SIZE <extent_size>
SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE test_bed LOGGING
DATAFILE '/test/sandbox/' SIZE 2048M
BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO; |
