adding a datafile to a tablespace?

[Former Member]

hi all,

what are the prequisites of adding a datafile to a tablespace

& how is it performed? pls help?

regards,

vivek.

[Former Member]

Hi,

prequisites of adding a datafile to a tablespace

1. check for Tablespace Threshold level should be more than 90%(in db02 tcode).

2. There shd be no backup running while adding datafile to Tablespace.

3. check for the size of datafile should be added to Tablespace.

Goto Brtools--->login as sidadm

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

select option 2 - Space management.> Then select 1 = Extend tablespace> 3 ~ Tablespace name (tablespace) ... []-->

5 - Size of the new file in MB (size) ..... [3500] then continuosly select c-continue

With this steps your datafile will be added to Tablespace.

Thanks,

Ramakrishna.

[Former Member]

thanks rama../it was helpful.