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