Re: Changing Tablespace file location?

Keir Evans wrote:
>
> I need to know how to move a tablespace file from one disk to another?
> As far I now you have to 1. Export the tablespace. 2. Read Tablespace
> storage parameters.
> 3. Drop the tablespace. 4 Re create the tablespace with the new disk
> location. 5. Import the data back in.
>
> Is there a better way?
If the tablespace is made up of only one datafile you could try renaming the datafile. I've not actually done it before but I suppose all you need to do is;
1. take the tablespace offline,
2. rename the datafile using a syntax similar to "ALTER TABLESPACE mytablespace RENAME DATAFILE '/myoldname.dbf' to '/mynewname.dbf';" 3. Do an operating system copy of the original datafile to the new disk location
4. Bring the tablespace back on-line.

In theory that should work.
If you have more than one datafile, I suppose you could do the same for all the datafiles. Received on Mon Oct 28 1996 - 00:00:00 CET