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: Oracle 7.2 - db_files - increase

Re: Oracle 7.2 - db_files - increase

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Wed, 09 Sep 1998 19:59:23 GMT
Message-ID: <01bddc3b$e8ca5fc0$a504fa80@mndnet>


Do you really want to add datafiles or do you simply want more disk space ?

You can resize your existing datafiles if you need more disk space.

alter database datafile 'u1/XYZ/user1' resize 800M;

Regards

Suresh

lauritzen_at_my-dejanews.com wrote in article <6t5v7q$2k1$1_at_nnrp1.dejanews.com>...
> How to increase the number of data files whitout reinstall oracle?
>
> OS:AIX 4.01/ HW:RISC/6000
>
> Thanking you in advance,
>
> Regards,
>
> Søren Lauritzen, Denmark
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Wed Sep 09 1998 - 14:59:23 CDT

Original text of this message

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