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 · Accepted solution]

first prerequisite is, you must have the space on filesystem/disk level, so that you can add/extend space at database/tablespace level. For rest of the prerequisite or concepts, you should read first what is tablespace and what is datafile and database concepts

We can use sapdba or brtools to extend the tablespace by adding a datafile

http://help.sap.com/saphelp_nw70/helpdata/en/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm

[Former Member · Accepted solution]

hey anjali,

The tablespace extension with brtools is fine but there is one more thing , there is script

which runs through schedule tasks on daily basis which calculate space & add space

in database ,basically it is increment of 20% at a time in db.It is possible in sap4.7 but not

in sap4.6.If u know about this script let me know.

regards,

vivek

[Former Member · Accepted solution]

I never heard of this kind of script, but yes you can keep the tablespace/datafile as 'autoextend' which will do the things as you thought just now.

Read about autoextend, first understand the concept and only then do something in database

[JPReyes]

This is an interview question.

The information is widely available and that only points to the fact that you didn't do any research before posting.

Read the "Rules of Engagement"

Regards

Juan

[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.