Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace question
shut the database
move the files
do a startup *mount* (so do NOT open)
alter database rename datafile etc.
should be sufficient.
Hth,
Sybrand Bakker, Oracle DBA
<kryptogenic_at_my-deja.com> wrote in message
news:91ta49$ahd$1_at_nnrp1.deja.com...
> I am very new to oracle so please forgive me if I'm horribly wrong
> here. I noticed in our database that a tablespace has 3 datafiles
> inside of it. The problem is that all 3 files are located in the same
> directory on the same drive. We have 3 different drives that we can
> place files on so my intent is to move 2 of the files to the 2 other
> drives. Now, my plan is to bring the database down, copy the files to
> the other drives at the unix level, then restart the database, take the
> datafiles offline and rename them to their new locations, then bring
> them back online. My questions is, is this the correct procedure?
> Thanks for any advice.
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 21 2000 - 12:08:36 CST