What is the process for changing dbfile names? For example, if we have dbfiles defined on the o/s
lrwxrwxrwx .........main1a-> /dev/zvol/rdsk/M_ANCHOR/m1
lrwxrwxrwx .........main2a-> /dev/zvol/rdsk/M_ANCHOR/m2
which are stored in the iq_main (user dbspace) as main1a and main2a
We want to rename them to main1, main2 (drop th 'a') in the file system and in the database.
I think this could be done with a restore (even a virtual restore). But is there a way to do this using
alter <dbspace> alter file main1a rename to main1?
What would the order be in this case?
We're on IQ 15.4, Solaris 10, do not have VLDB.