datafile adding

[Former Member]

Hi 2 all,

My sap ver 5.0 ECC, OS HP-UX 11.23, database oracle 9.2.0.4,. I need to know how to identify when to add datafiles , and How to add datafiles, explain me the process..........in detail please...........

Regard's

Rajkumar

Message was edited by:

Raj kumar sindol

[Former Member]

Hi Raj,

1) In <b>DB02</b>transaction, we can analyse database growth. Run transaction <b>DB02</b> --> Click on <b>current sizes</b> (it will display tablespaces present in your system) --> Click on <b>Tablespace history</b> where we can analyse the growth of each tablespace on daily, weekly and month basis.

<u><b>Adding a datafile using BRTOOLS</b></u>

1) su – <b>ora<sid></b>

2) start <b>brtools</b>

3) Select option <b>2 -- Space management</b>

4) Select option <b>1 -- Extend tablespace</b>

5) Select option <b>3 --Tablespace name</b> (specify tablespace name) and say continue(c- cont)

6) Select option <b>3 – New data file to be added</b> and return

7) Select option <b>5 -- Size of the new file in MB</b> (specify the size of the file) and say continue

regards,

kanthi

[Former Member]

If your talbe space is full and the autoextended mode is off then you have to extend the table space and add the data file. if your autoextended mode is on you need to add a data file it will add automatically.

You can add the data file by BRTOLLS

Regards

Subhash