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 ?

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 22 09:14:30 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.