Re: rename a data file

Please check out the SQL Reference manual for additional information related to the use of these two commands.

/Hans

dc wrote:

> What I would do is either:
>
> ALTER DATABASE RENAME FILE '/oradata/file-name1' TO
> '/oradata/file-name2' ;
>
> or
>
> ALTER TABLESPACE tablespace-name RENAME DATAFILE '/oradata/file-name1'
> TO '/oradata/file-name2' ;
>
> Hope it helps.
>
> kowalsky a écrit :
>
> > Hi all,
> > my question is very simple: I want to rename a data file of an
> > existing Oracle 8.1.7 database. How do I do it?
> > Thanks,
> > kowalsky
Received on Tue Jul 03 2001 - 01:44:10 CDT