Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MAXDATAFILES Question
You have another option in 7.2 or higher resize existing data files up to
2G:
alter database datafile '/r1/xyz/tnam01' resize 500M;
Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com
Billy <spamguard_at_home.com> wrote in article <36097BCD.1BF505D7_at_home.com>...
> Hi, it's me...Billy (I'm only 12 years old).
>
> Yikes, how do I change this to allow more data files. My system sez it
> only allows 32 db files but I have 34. I still need to add 2
> more...Ohhh, my head hurts.
>
> Thanks,
> Billy
>
>
Received on Thu Sep 24 1998 - 09:39:47 CDT