Main doubt is if I have to do it using: Shutdown instance, mv Unix command, alter database rename... and so on even if I want to rename System tablespace datafiles.Yes, use the standard procedure alter database rename datafile command.
Hi all,But you have never been clear from the beginning. You should have asked simple question in a simple way.
I just have a question.
In my DB I have db_create_file_dest as TRUE parameter (only that one).
Can I set it as FALSE parameter with alter system set DB_CREATE_FILE_DEST='' scope=both clause without problem?
I have a pshysical standby in that DB so, have I to change the parameter on Standby instance and rename the Oracle Managed Files labeled datafiles too?
Thanks a lot.