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