Re: How do I move a tablespace from disk to disk on NT

From: <rspeaker_at_my-dejanews.com>
Date: Thu, 22 Oct 1998 14:45:22 GMT
Message-ID: <70nge2$uip$1@nnrp1.dejanews.com>

I'm not sure about NT, but on AIX you would do something like this:

alter tablespace <ts_name> offline;

then from the OS, copy the datafiles from disk1 to disk2

then alter tablespace <ts_name>

rename datafile 'old_datafile_name' to 'new_datafile_name';

be sure to use full path names for the old and new datafiles

next issue a recover tablespace <ts_name> then alter tablespace <ts_name> online;

Hope This Helps...

In article <70ndlh$rtu$1_at_nnrp1.dejanews.com>, bonanos_at_yahoo.com wrote:
> Amigos
>
> Is there a way to move the datafiles of a tablespace from one disk to another
> on NT
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 22 1998 - 09:45:22 CDT