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: Moving datafile

Re: Moving datafile

From: johnkoo <johnkoo_at_i-wave.net>
Date: Wed, 30 Dec 1998 07:58:38 -0000
Message-ID: <9#FY6c4M#GA.178@news.powernethk.com>


You might use the following command to add file to your datafile ,say, ts1:

   alter tablespace ts1 add datafile '/xxx/xxx/file2.dbf' size xxM ... without bringing the database down or tablespace offline.

John

Doug Cowles wrote in message <3688846C.BA79CF86_at_i84.net>...
>Another question - can someone outline basic
>steps for moving a datafile without bringing
>the database down? Running out of space on
>filesystem.
>
>- Dc.
>
Received on Wed Dec 30 1998 - 01:58:38 CST

Original text of this message

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