Custom Search
www.rocket99.com : Technical Guides Sybase Oracle UNIX Javascript


Technical Guides
Sybase
Oracle
UNIX
Javascript




Of Interest

Business Intelligence and Analytics



Oracle Training





Oracle » Administration » DBA »

Increasing the size of a tablespace

     







1) Add a data file

ALTER TABLESPACE ts03
ADD DATAFILE
'/data1/oradata/ts03-b.dbf'
SIZE 200M ;

ALTER TABLESPACE ts01
ADD DATAFILE
'/data/disk12/dataxx44.dbf' SIZE 200M
AUTOEXTEND ON NEXT 10M
MAXSIZE 500M;


2) or, resize current data file

alter database datafile '/u01/oradata/orcl/users01.dbf' resize 50M;



3) or, change the storage / extent configuration

ALTER TABLESPACE ts01
DEFAULT STORAGE (
INITIAL 200M NEXT 200M MAXEXTENTS 10 ) ;




/* Altering the default storage for a tablespace */

ALTER TABLESPACE TEMP01 DEFAULT STORAGE (PCTINCREASE 0)

ALTER TABLESPACE TEMP01 DEFAULT STORAGE ( initial 1M next 1M )













Oracle : Related Topics

Oracle : Administration : Server Manager
Oracle : Administration : O/S Password Authentication
Oracle : Administration : Database Creation
Oracle : Administration : Tablespace Creation
Oracle : Administration : Rollback segments
Oracle : Administration : Adding a redo log file set
Oracle : Administration : Altering table storage
Oracle : Administration : Backing up data files
Oracle : Administration : Taking tablespaces offline
Oracle : Administration : Creating users
Oracle : Administration : DB Verify
Oracle : Administration : Clearing Log Files
Oracle : Administration : Moving Data Files
Oracle : Administration : Index Management
Oracle : Administration : Creating a Schema
Oracle : Administration : Enabling Archive Logging
Oracle : Administration : Updating statistics for a table or schema
Oracle : Administration : Killing Sessions
Oracle : Administration : Recovering an Instance
Oracle : Administration : Drop a table and deallocate space
Oracle : Administration : Dropping a Tablespace
Oracle : Administration : Restricted Mode
Oracle : Administration : Oracle Issues, Facts You Should Know

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site



Get the latest Rocket99 news and tech tips via






Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site




Copyright © 2016 Stoltenbar Inc All Rights Reserved.