Re: Moving datafile

From: Reid Lai <reidlai_at_hk.super.net>
Date: Wed, 06 Jan 1999 17:51:11 +0800
Message-ID: <3693320F.F81EFDB0@hk.super.net>

Will it get any problem because the file /xxx/xxx/file2.dbf is empty. The problem here is to more file location only.

johnkoo wrote:

> 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.
> >

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net> Received on Wed Jan 06 1999 - 03:51:11 CST