RE: Moving Datafiles

1)Use svrmgr
2)Connect internal
3)Shutdown your database.
4)Copy datafiles to new location(which you want to move).
5)Startup mount;
6)Alter database rename datafile 'old_location' to 'new_location';
7)Alter database open;

Vikas

-----Original Message-----

From: Calvin Lim [mailto:calvin-lim_at_mediaring.com] Sent: Friday, June 16, 2000 7:02 AM
To: Multiple recipients of list ORACLE-L 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).