Oracle Table Space Management

CREATE TABLESPACES

SQL> CREATE TABLESPACE TABLESPACE_NAME DATAFILE 'C: / ORACLE/Ordata/file1.dbf' size 100m,

SQL> 'c: /oracle/oradata/file2.dbf' size 100m minimum eXtent 550k [logging / nologing]

SQL> Default Storage (Initial 500K Next 500K MaxExtents 500 Pctincce 0)

SQL> [Online / Offline] [Permanent / Temporary] [EXTENT_MANAGEMENT_CLASE]

2.locally management tablespace

SQL> CREATE TABLESPACE USER_DATA DATAFILE 'C: / ORACLE/Ordata/User_data01.dbf'

SQL> Size 500M Extent Management Local Uniform Size 10M;

3.Temportory TableSpace

SQL> CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'C: / ORACLE/Ordata/temp01.dbf'

SQL> Size 500M Extent Management Local Uniform Size 10M;

4.change the storage setting

SQL> ALTER TABLESPACE APP_DATA Minimum Extent 2M;

SQL> ALTER TABLESPACE APP_DATA Default Storage (Initial 2M Next 2M MaxExtents 999);

5.TAKING TABLESPACE OFFLINE ORINE

SQL> ALTER TABLESPACE APP_DATA OFFLINE;

SQL> ALTER TABLESPACE APP_DATA online;

6.Read_only TableSpace

SQL> ALTER TABLESPACE APP_DATA Read Only | Write

7.Droping TableSpace

SQL> Drop tablespace app_data incrududing contents;

8.enableing Automatic Extension of Data Files

SQL> ALTER TABLESPACE APP_DATA Add DataFile 'C: /oracle/oradata/app_data01.dbf' size 200m

SQL> AutoExtend on Next 10M MaxSize 500M;

9.change the size fo data files manually

SQL> ALTER DATABASE DATAFILE 'C: /Oracle/oradata/app_data.dbf' Resize 200M;

10.Moving Data Files: ALTER TABLESPACE

SQL> ALTER TABLESPACE APP_DATA RENAME DATAFILE 'C: / ORACLE/Ordata/App_data.dbf'

SQL> To 'c: /oracle/app_data.dbf';

11.Moving Data Files: ALTER DATABASE

SQL> ALTER DATABASE RENAME FILE 'C: /Oracle/oradata/app_data.dbf'sql> to' c: /oacle/app_data.dbf ';