Home » RDBMS Server » Server Administration » add a deleted datafile again.
add a deleted datafile again. [message #64557] Tue, 08 February 2005 01:37 Go to next message
sri
Messages: 154
Registered: February 2000
Senior Member
The scenario is
I have deleted a datafile belonging to a Tablespace say A using the command

ALTER DATABASE DATAFILE 'a1.dbf' offline drop;

The datafile exists in the same location .Its not physically deleted from the disk.

Now i want to add the datafile again back to the Tablespace.

What do i need to do

Report message to a moderator

Re: add a deleted datafile again. [message #64559 is a reply to message #64557] Tue, 08 February 2005 03:39 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

You can issue an "ALTER TABLESPACE ... ADD ..." command with the REUSE clause. Note that the file will be reinitialized and everything it is will be gone!

Best regards.

Frank

Report message to a moderator

Previous Topic: Upgrade issue?
Next Topic: Table and index size
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 04:03:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.