Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Resizing a Datafile
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