Snippet Name: TABLESPACE: Permanent Tablespace Using A Raw Device Description: Example of creating permanent tablespace on a raw device. 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 » USER tablespace quota » USER temp tablespace » USER tablespace » USERS: Grant tablespace access » Nested Loops: loop through tables » SEQUENCE: Autonumber into two tables » RAWTONHEX » RAWTOHEX » HEXTORAW » Count rows in all tables » List tables with more than 'X' rows » List analyzed tables with un-analyzed ... » Compressed Tablespace Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 12th, 2009
Description: Example of creating permanent tablespace on a raw device.
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 » USER tablespace quota » USER temp tablespace » USER tablespace » USERS: Grant tablespace access » Nested Loops: loop through tables » SEQUENCE: Autonumber into two tables » RAWTONHEX » RAWTOHEX » HEXTORAW » Count rows in all tables » List tables with more than 'X' rows » List analyzed tables with un-analyzed ... » Compressed Tablespace
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 testbed LOGGING DATAFILE '/test/sandbox/' SIZE 1024M BLOCKSIZE 4096 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTO;
