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