Re: ddl help

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<6W4w9.66455$g9.186431_at_newsfeeds.bigpond.com>...
> Alter tablespace BLAH offline;
> c:\> copy dbf1.dbf dbf2.dbf
> Alter database datafile rename 'c:\dbf1.dbf' to 'c:\dbf2.dbf';
> Alter tablespace BLAH online;
>
> Regards
> HJR
>
>

Horward
I believe the database has to be mounted only but not opened before files can be renamed?
Michael Tubuo Ngong Received on Thu Oct 31 2002 - 09:03:30 CST