Renaming datafile of tablespace
Hi All,
By mistake I added a datafile with same number to a tablespace. We follow a convention for adding datafile to tablespaces. Whenever we add datafile we increase the number prefix for datafile. for example /u01/datafile/tablespace01.dbf then /u01/datafile/tablespace02.dbf etc. for a tablespace at the time of adding datafile to a tablespace I gave such a prefix number to my datafile that was already given earlier but in a different mount point. That mistake was done at the time of checking the datafile name in TOAD. To do this task correctly now I do it by querying dba_data_files view though it takes little more time to know the last filename. Anyway How can I rename that datafile or move a datafile to other location. tablesapce size is huge 328GB and database size is more than 1.5 TB . I can not shutdown the database as I want to undo my mistake without hampering the system and a downtime. Please help me showing the best way to perform it.
Please help..
Thank you For your Great Support.