Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: TABLESPACE: Oracle Managed Auto-extendable Tablespace Jump to:  
Category: >> Oracle PL/SQL >> TABLESPACE: Oracle Managed Auto-extendable Tablespace Bookmark and Share

<< lastnext >>

Snippet Name: TABLESPACE: Oracle Managed Auto-extendable Tablespace

Description: Examples of creating a Oracle-managed tablespace with both fixed and auto-extendable tablespace.

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: Permanent Tablespace Using...
» TABLESPACE: Using Raw Devices
» TABLESPACE: permanent tablespace

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 12th, 2009

-- Oracle-managed permanent with auto-extendable tablespace:
 
-- syntax: 
CREATE TABLESPACE <tablespace_name>;
 
 
-- example: 
ALTER SYSTEM SET DB_CREATE_FILE_DEST = $ORACLE_BASE/testbed';
CREATE TABLESPACE sales_data;
 
 
 
--Oracle-managed fixed size tablespace (permanent):
 
-- syntax: 
CREATE TABLESPACE <tablespace_name>
DATAFILE AUTOEXTEND OFF;
 
-- example: 
ALTER SYSTEM
SET DB_CREATE_FILE_DEST = $ORACLE_BASE/oradata';
 
CREATE TABLESPACE user_data DATAFILE AUTOEXTEND OFF;
 
 
-- To allow a table to extend itself indefinitely:
 
ALTER TABLE sales_us storage (maxextents unlimited);
 
-- To allow a tablespace to extend itself indefinitely, the 
-- following syntax is used:
 
CREATE tablespace
Sales_US
Datafile
'/test/sandbox/sales/client.dbf'
size
400M
AUTOEXTEND ON
next 20M 
MAXSIZE UNLIMITED;


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 189 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?