Skip to Content
Former Member
May 21, 2015 at 04:36 PM

Changing dbfile names


What is the process for changing dbfile names? For example, if we have dbfiles defined on the o/s

as follows:

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.