Holger Baer <holger.baer_at_science-computing.de> wrote in message news:<cimorn$4i5$1_at_news.BelWue.DE>...
> We live and learn. I always thought for rename datafile you need
> to mount the database?
... and we do mistakes and have memory problems. You're right indeed.
It would be hard to rename datafile in the phase when a database know
nothing about them. So the correct sequence is:
- shutdown database
- copy your file from its current destination to the second one
- startup mount
- alter database rename file '/oracle/data/file.dbf' to
/ora/file.dbf';
- alter database open
--
Dusan Bolek
http://www.db-support.com
Email: spambin_at_seznam.cz
Pls add "Not Guilty" to the subject, otherwise your email will face an
unpleasant end as SPAM.
Received on Wed Sep 22 2004 - 02:02:23 CDT
