I currently have a small V7.33 database running on Alpha under OpenVMS V7.1
I want to move the database from one disk to another.
I have closed down the database and copied it to the new disk but I need to be able tell Oracle the new database location.
If I simply try to change the file location within the DBA_DATA_FILES table I get the Oracle error
ORA-02030: can only select from fixed tables/views
I guess this is because the database is still open when I issue the update command.
Can you please tell me if it is possible to move the database files from one disk to another and if so how.
Could it perhaps be done by changing the logical name of the disk within OpenVMS?
I want to move the database from one disk to another.
I have closed down the database and copied it to the new disk but I need to be able tell Oracle the new database location.
If I simply try to change the file location within the DBA_DATA_FILES table I get the Oracle error
ORA-02030: can only select from fixed tables/views
I guess this is because the database is still open when I issue the update command.
Can you please tell me if it is possible to move the database files from one disk to another and if so how.
Could it perhaps be done by changing the logical name of the disk within OpenVMS?