Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MAXDATAFILES Question

Re: MAXDATAFILES Question

From: Oracleguru <oracleguru_at_mailcity.com>
Date: Thu, 24 Sep 1998 14:39:47 GMT
Message-ID: <01bde7d8$bdf8e700$a504fa80@mndnet>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US