Resizing the datafile of oracle database

[Landan]

Hi,
I used the below command to create a datafile.

SQL> create tablespace new datafile '/gxsdb/database/oradata4/RCA/RCA_REF_CFM_PROP_DATA.dbf' resize 1M;

After this , I want to increase the size of the datafile again in order to use more space ? It was already altered for a while/period of time .How can I do this ? Any suggestion ?
Can you introduce me to different ways to increase the size of datafile.

[Reegan]

The storage of the contents of your database objects.In the logical way,we called it as tablespace and physically indicate it as a datafile.

The collection of one or more datafile is called as a tablespace.If you are going to allocate more space to tablespace then definitely, you are resizing the datafile .

There are three ways to increase the space of the a datafile :

1. Resizing of datafile using RESIZE command
2. Adding more datafile using ADD DATAFILE
3. Using AUTOEXTEND command

[opaper]

Using RESIZE command :

If you are using a database and you need more space to store some object in the tablespace, you have to increase the size of datafile.

Here, I am going to elaborate the space adjustment using RESIZE command.

SQL> ALTER DATABASE DATAFILE '/u01/oracle/vikdb1/stuff01.dbf'
   RESIZE 100M;

After using this command,your datafile has been the size of 100M.In this way,you can alter the size of your datafile later.

[MindSpace]

Using AUTOEXTEND command:

You can resize your datafile using AUTOEXTENTD command with the name of datafile.You can use it due to creation of database or after.You can use it with the create tablespace statement .

With Create tablespace statement:

SQL> CREATE TABLESPACE DATAFILE '/u01/oracle/db1/users03.dbf' SIZE 10M AUTOEXTEND ON;

After creation :

SQL> ALTER DATABASE DATAFILE '/u01/oracle/db1/users03.dbf'
AUTOEXTEND ON;

[Modifier]

Using ADD DATAFILE command:

You can use more than one datafile with one tablespace. In this case, we are going to associate another datafile with a tablespace.This would be done as follows :

SQL> ALTER TABLESPACE Mine 
        ADD DATAFILE '/u02/oracle/Moddb/Mine02.dbf' SIZE 20M;