| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rename Datafile
> -----Original Message-----
> From: Thater, William [mailto:ThaterW_at_telergy.net]
>
> On Mon, 7 May 2001,Hillman, Alex scribbled on the wall in
> glitter crayon:
>
> ->Why not to make tablespace offline, rename datafile in
> oracle and them use
> ->unix mv command to move it? Copy is not good ig there is no space.
>
> Well, the time I tried it, ORACLE didn't like the fact the
> new file wasn't there first. But that was in version 7.3.2
> so maybe in 8x that would work.
I have taken the tablespace offline, renamed the datafile in the OS, after the OS rename used 'alter database rename file' in SQL*Plus, then successfully brought the tablespace back online. This was in Oracle 8.0, 8.1 on SunOS and Windows NT/2000.
 |
 |