Home » RDBMS Server » Networking and Gateways » How rename a datafile
How rename a datafile [message #367765] Mon, 20 March 2000 07:36 Go to next message
Ali
Messages: 88
Registered: March 2000
Member
HI
how to rename a datafile related to a tablespace ?
Re: How rename a datafile [message #367766 is a reply to message #367765] Mon, 20 March 2000 09:55 Go to previous message
Thierry Van der Auwera
Messages: 44
Registered: January 2000
Member
Hallo Ali,

Follow these steps.

shutdowm immediate

Alter the name of the datafile with Windows explorer.

startup mount
connect internal
ex : alter database rename file 'C:\ORACLE\DATA\DATA1.ORA' TO 'C:\ORACLE\DATA\DATA99.ORA';
shutdown the database
startup

This must be it.

(See if you have a backup, you never know.)

Greetings,

Thierry.
Previous Topic: net8 with oracle7
Next Topic: SELECT DISTINCT not processed by NET8
Goto Forum:
  


Current Time: Mon Mar 04 19:59:33 CST 2024