Re: Moving a tablespace to another drive !
Date: Mon, 25 Jul 1994 21:47:09 GMT
Message-ID: <sivar.15.0010C9A9_at_gscrb.sandiegoca.ncr.com>
In article <310fa4$7ju_at_netserver.univ-lille1.fr> noel_at_omega.univ-lille1.fr (Yves Noel) writes:
>From: noel_at_omega.univ-lille1.fr (Yves Noel)
>Subject: Moving a tablespace to another drive !
>Date: 25 Jul 1994 13:39:16 GMT
>Hi all DBA's
>The scenario : one tablespace (content : rollback segments and temporary files)
>which has been increased three times with a new file, so it contains now 4 files
>(with the command : alter tablespace xxx add datafile ...).
>Today I've new drives and I want in particular to move this tablespace and it's
>four files on a new drive.
>Can somebody tell me the differents stages to do this ? Thanks in advance.
>Email: Yves.Noel_at_univ-lille1.fr
- Shut down the database and take a backup including control files, log files, parameter files -- i.e. the works.
- Copy the files to the destination drive
- Start up SQL*DBA and do a startup mount
- Rename the data files to point to the new directory: alter database rename file '/directory1/file1' to '/directory2/file1';
- Repeat with other data files
- Open the database: 'alter database open'
- If all is OK, you might like to shutdown the database and backup the database again.
Siva Received on Mon Jul 25 1994 - 23:47:09 CEST