data file

[Former Member]

how much maximum data file add in sapdba and brtools

[Former Member]

ignore.it was typo mistake for nother query

Edited by: Gokul Bhogabandi on May 24, 2008 11:23 AM

Edited by: Gokul Bhogabandi on May 24, 2008 11:23 AM

[Former Member]

i am asking how much maximum data file add at a time(one attempt)?

[fidel_vales]

as Markus mentioned:

> OS + and filesystem specific

I add that also depends on your parameters.

See note Note 129439 - Maximum file sizes with Oracle for details

[Former Member]

Hi Praveen,

We add datafile only when the tablespace is filled.

purely it depends on space in hard disk.

Example:

if u have installed Oracle DB in 250 GB drive appx 120 -160 GB is occupied for oracle data file... Of that still u have 90 GB free... so when ever your tablespace if filled you can add data file.. this is done till u reach the maximum of 250 GB (hard disk space)

Reward Points if it is help ful

Regards

Bala

[markus_doehr2]

OS + and filesystem specific.

Markus