Re: Moving Datafiles

From: djordjej <djordjej_at_attcanada.ca>
Date: Thu, 15 Jun 2000 22:41:13 -0400
Message-Id: <10529.109494@fatcity.com>

Method 1: cannot be used for the SYSTEM tablespace

   Take tablespace offline
   O/S copy the files
   ALTER TABLESPACE TablespaceName
    RENAME DATAFILE ‘OldName’ TO ‘NewName’;    Bring the tablespace online

Method 2

   Shutdown the database
   O/S copy the files
   Startup mount the database
   ALTER DATABASE RENAME FILE ‘OldName’ TO ‘NewName’;    ALTER DATABASE OPEN; Djordje

-----Original Message-----
From: Calvin Lim <calvin-lim_at_mediaring.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thursday, June 15, 2000 8:53 PM
Subject: Moving Datafiles

>Hi all,
>
>We've just added a few spindles to our DB and I need to move
>datafiles for some of my tablespaces across to the newer spindles
>in order to spread the io. What are the steps i've got to take
>to achieve the movement of the datafiles?
>
>Thanks again for all your help.
>
>Regards,
>Calvin
>
>-----BEGIN PGP PUBLIC KEY BLOCK-----
>Version: PGPfreeware 6.0.2i
>
>mQENAziIKPcAAAEIAMOziD1YcgivJCdmdMaQftSrMhnL6uXjz9Fh6c2FjDbEwLb1
>gHAYk8bdlaWLPspacuwo5mjzCc5uUvNualORP+tLxGNY9GiMdHMUfUdNLxv7EU4+
>6WxaXwyzz5DZUQiwLsvg12+ZSLOuOL4BLu8oJH9MBSPa/9aaYGDpQ845L6JJP5t1
>uDDsG26k6gnenOfT+ZaEgFTFpYQbfXN7X16dc726AcEuSG8NUjK3thA3ol9m8768
>cCELkc82w55HNH5b4TeF9obapJrXgOLqnf2pi4mUodao5dFewW/U46zPcz2giRp4
>gVPAmJFs+s8OjKY74D3aXH7QWg7bLrLOrBG3pkUABRG0L0NhbHZpbiBMaW0gU3dl
>ZSBLaGlhbmcgPGNhbHZpbl9saW1AaG90bWFpbC5jb20+iQEVAwUQOIgo9y6yzqwR
>t6ZFAQFrTAf+Lw6aI0wSfOooU1n9qw0zdL4o0U4ZH+XAgzn8BoVcv0U1bA0U1ckg
>pDY5TVfR0hQg7DQyUvh1AKxeD9D6OTFpg/TE3BPD49iq/LS3uuUbfIGmhsE6AmM1
>SiRwwmA5n5IZTWDYHrocBJegV5Hk3iHJeDjCKvX/CZCZH4CGJ/2y/THfa6I9eDfF
>kmZ8f90cM4hZ9YiqLSslNf5hztJZzEfBuSs7Zz6tHRQFlCucn5mlKPNM+ig4FBdS
>f6ISUMxQxZB2xbFwYDn+qjB6eF8HianPP7XCQUSQNJeWKQ9pkJ7QOZeEKvRYZHp2
>tLNw34pJ8cHoOIGS7FAi+OX2IfyyOvehkw==
>=FOMk
>-----END PGP PUBLIC KEY BLOCK-----
>--
>Author: Calvin Lim
> INET: calvin-lim_at_mediaring.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Thu Jun 15 2000 - 21:41:13 CDT