Tablespace and Datafile Management

1.Creating tablespaces, Adding and Resizing datafiles

SQL>create tablespace <Tablespace_name> datafile '<datafilelocation>' size 128m autoextend on next 128m maxsize unlimited;

SQL>create tablespace USERS datafile '/soadev/oradata/soadohr2/datafile/users01.dbf' size 128m autoextend on next 128m maxsize unlimited ;

2.Resing the datafile

SQL> alter database datafile'/d01/oracle/PROD/proddata/apps_ts_tx_idx538.dbf' resize 6144M;

3.adding datafile

SQL>alter tablespace <Tablespace Name> add datafile <path of the datafile> size 500m;

SQL>alter tablespace tbs add datafile '/d01/oracle/prod/tbs05.dbf' size 500m;

4.create tablespace in RAC Environment

SQL>create tablespace <TABLESPACE_NAME> datafile size 128m autoextend on next 128m maxsize unlimited;

SQL>create tablespace USERS datafile '+DATA' size 128m autoextend on next 128m maxsize unlimited ;

5.Add datafile in RAC Environment 

SQL>alter tablespace <Tablespace_name> add datafile '+DATA' size 128m autoextend on next 128m maxsize unlimited;

SQL>alter tablespace UNDOTBS1 add datafile '+DATA' size 128m autoextend on next 128m maxsize unlimited;