Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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