Extending existing DataFile

[former_member199632]

Hello,

I have added 1 data file to PSAPSR3 table space successfully using brtools. (When DB is online)

Datafile Size: 9 GB (Maxlimit is also set to 9GB)

Now there are 15 data-files , each max limit is 9 GB in size.

These data file additions can be performed , when the DB is in online mode.

but when adding datafiles each time, it will higher the datafile count..... and will be difficult to manage.

therefore, im thinking of extending the size of the existing datafiles

I need to know,

what if I want to extend the size of existing datafile.

Size is already reached to its maxsize.

(for example.... if datafile size is 9 GB and maxlimit is also 9 GB)

Can we perform this kind of task, while the DB is online.? or else do we need to shutdown the DB and perform the task using brttols.

- Is there any file size limitation that can be extending?

regards,

[Former Member · Accepted solution]

Hi,

You can just resize the existing datafile using brtools or directly via sqlplus.

Just enter: alter database datafile <datafile name> resize 20480M; (just enter a size).

You can set the autoextend maxsize to the new size of the datafile.

All above activities can be executed online. The max size of a datafile is huge, so you don't have to worry about that..

Kind regards,

Mark

[former_member204746]

try this command:

brspace -c -u / -f dfalter

turn auto-extend on and you can use max_size up to 32GB if you want.

just make sure that your disks can hold that much information before changing this.

good luck.

[Former Member]

Check this link too [http://help.sap.com/saphelp_nw70ehp1/helpdata/en/f1/5e863f06593a17e10000000a114084/content.htm]