Adding a new data file into an Oracle 10g instance

Oracle · Databases
Databases · Oracle

First thing we need to check where the data files are being stored to do this all you need to do is log in as sysdba and then run ‘select * from dba_data_files;’

e.g.

    SQL> connect / as sysdba
    Connected.
    SQL> select * from dba_data_files;

Once you have the location the syntax for adding the file is

    SQL> connect / as sysdba
    Connected.
    SQL> alter tablespace data_large add datafile '/lh0-mmm-sync/oracle/oradata/data0/data_large02.dbf' size 1g;

Note: Oracle will create the data file for you, you don’t need to make the file though the OS or anything. One big thing to check before you run this command is to make sure you have enough physical disk space.

Share