Re: rename a data file

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 Thu Jun 28 2001 - 12:59:04 CDT