Re: Oracle10g temporary tablespace and datafiles

you need to rename the files in the data dictionary.

Take tablespace offline
move datafiles to location you want
rename the file in the database
online the tablespace

On 08/05/06, Svetoslav Gyurov <softice_at_gmail.com> wrote:
>
> I have Oracle10g R1 on rp5470/L3000 with HP-UX 11.23. The database
> grow up so we had to move it from the local disks to storage. The
> storage volumes were mounted under the old mount points, but because
> of some type of load balancing (alternative paths) some of the
> datafiles had to be moved to other locations. I used to move all of
> them except the temporary datafiles and at the moment I'm using
> symbolic links to point to the new locations. I didn't found any
> solution except something I read, it says that I have to add new
> temporary datafile (which will be ot the correct location) to the
> temporary tablespace and after that removing the old temporary
> datafile from the tablespace. And now the question is can I move these
> files to the new locations and get rid of the symbolic links. I wasn't
> able to test that and I'm curious of your opinion.
>
>
>

--
http://www.freelists.org/webpage/oracle-l