Re: Changing Tablespace file location?

In article <01bbc442.ebebb7c0$d48277ce_at_kre.tiac.net>, kre_at_tiac.net says...
>
>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 you have Oracle 7.2.3 or higher, you can Relocating Datafiles as described below:

1. Back up the Database
2. Take the tablespace offline.
3. Copy the datafiles to their new location (operating system command) (e.g hp-ux command cp file1 newfile)
4. Using sql command to rename the datafile ALTER DATABASE .... RENAME FILE command.
5. Bring the tablespace online.
6. Back up the Database.

Tan. Received on Mon Oct 28 1996 - 00:00:00 CET