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: Resizing a Datafile

Re: Resizing a Datafile

From: Christophe Nicolas <cnicolas_at_mail.dotcom.fr>
Date: Sun, 20 Dec 1998 22:06:46 +0100
Message-ID: <75jotd$128$1@oceanite.cybercable.fr>


Don't forget you must indiquate the path for your datafile in the Alter database command.

_\\//

Christophe Nicolas, expert Oracle
www.capway.com/nicolas4/oracle/oracle.htm

Scott a écrit dans le message <367b496d.19213848_at_news.localnet.com>...
>Hello -
>
>I am pretty new at Oracle - We have Oracle 7 running on SCO Unix. I
>would like to know if you have to bring the database down to manually
>resize a datafile (or can I just keep everything running) ?
>
>I was planning on using:
>
>ALTER DATABASE DATAFILE 'file1.dbf'
>RESIZE 15M;
>
>Thank You for your help !
>
>scottrp_at_localnet.com
Received on Sun Dec 20 1998 - 15:06:46 CST

Original text of this message

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