Well, I got lots of answers about this issue, and all of them were
pretty simple, being what I asked the simplest of them. Many suggested
that I should do a backup and then a restore of my database in different
directories and then redefine the path of the data files in the
tablespace definition. It isn't a complicated task, thought this isn't
the way I did it. I rather copied all the data directory from one
filesystem to a different one. Then I renamed the old data directory,
created a link to the new directory in the other filesystem, and
restarted Oracle. It worked fine. Now I will be measuring the
performance of this, if it decreases, I'll change the path to the
tablespace files.
Thanks a lot for your answers.
--
-----------------------------------------------------------------------
Jorge L. Noyola Picazzo | Internet: jpicazzo_at_mex.cummins.com
Systems Analyst | Phone: +52 (48) 24-0005 x1165
Cummins Engine Co., Mexico Plant | Fax: +52 (48) 24-0231
-----------------------------------------------------------------------
Received on Sat Oct 12 1996 - 21:08:37 NZDT