Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Move database files from one disk to another. 1

Status
Not open for further replies.

Sanibel

Technical User
Nov 15, 2001
73
GB
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?

 
startup nomount
alter database rename file 'filespec' to 'filespec'

Alex
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top