> -----Original Message-----
> From: Thater, William [mailto:[EMAIL PROTECTED]]
>
> 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.
------
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
