Steps to be followed to move datafiles:
1)shutdown the database(normal/immediate)
2)take a backup as precautionery method
3)move what all datafiles u want to move to the
locations you want
4)start the database in mount stage
5)point the database to new locations of the
datafiles.
this can be done using the sql statement:
"alter database rename datafile 'old_name' to
'new_name';" (ofcourse, through svrmgr)
6)open the database.
Surendra Tirumala
DBA,
Satyam,India
- Calvin Lim <calvin-lim_at_mediaring.com> wrote:
> 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 - 20:24:25 CDT
