RE: Moving Datafiles

It's 'rename file' instead of 'rename datafile' in step (5) below.

• Kirti
  > ----Original Message-----
  > From: Surendra Tirumala [SMTP:stirumala72_at_yahoo.com]
  > Sent: Thursday, June 15, 2000 9:34 PM
  > To: Multiple recipients of list ORACLE-L
  > Subject: Re: Moving Datafiles
  >
  > 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).
  >
  >
  > __________________________________________________
  > Do You Yahoo!?
  > Send instant messages with Yahoo! Messenger.
  > http://im.yahoo.com/
  > --
  > Author: Surendra Tirumala
  > INET: stirumala72_at_yahoo.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