Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ddl help
No such requirement exists. All that is required is to take the
tablespace offline and execute the 'ALTER DATABASE DATAFILE RENAME
...' command AFTER the file has been physically moved or renamed at
the O/S level. Then bring the tablespace back online with the new
file name, just as Howard has illustrated.
mngong_at_yahoo.com (michael ngong) wrote in message news:<ecf365d5.0210310703.1e9888ff_at_posting.google.com>...
> "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 - 13:42:45 CST