Xref: alice comp.databases.oracle.server:28674
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!korova.insync.net!insync!not-for-mail
From: "Suresh Bhat" <suresh.bhat@mitchell-energy.com>
Subject: Re: Oracle 7.2 - db_files - increase
Newsgroups: comp.databases.oracle.server
References: <6t5v7q$2k1$1@nnrp1.dejanews.com>
Message-ID: <01bddc3b$e8ca5fc0$a504fa80@mndnet>
X-Newsreader: Microsoft Internet News 4.70.1155
Lines: 25
Date: Wed, 09 Sep 1998 19:59:23 GMT
X-Complaints-To: news@insync.net
X-Trace: insync 905371163 209.113.28.65 (Wed, 09 Sep 1998 14:59:23 CDT)
NNTP-Posting-Date: Wed, 09 Sep 1998 14:59:23 CDT
Organization: Insync Internet Services, Inc.

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@my-dejanews.com wrote in article
<6t5v7q$2k1$1@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
>