Skip to Content
0
Former Member
Aug 25, 2007 at 06:08 AM

Adding Datafile more than 2GB in SAPDBA, R3 4.71, Oracle 9.2.0.7, SunSolari

18 Views

Hi,

I need to add 4GB datafile (Default= 2097152KB). While trying to change to 4194304KB, it is showing warning "Specified size of datafile is greater than 2048M - 8K! (max_file_size in profile initSID.dba minus ORACLE data file header) Do you really want to continue? (y/n)"

So should I need to change in initSID.dba profile first and also i need to add only 2GB for some other table spaces. we have 27 table spaces.

what are the steps required to add more than 2GB datafile

Can some one help me out. . .

Thanks in advance . . .