Home » RDBMS Server » Server Administration » REUSE option-tablespace
REUSE option-tablespace [message #156797] Fri, 27 January 2006 20:51 Go to next message
nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA
Junior Member
In a statement

alter tablespace add datafile '/data/data01.dbf' size 100m reuse;

what it is the meaning of reuse clause

Thanks,
N

Report message to a moderator

Re: REUSE option-tablespace [message #156808 is a reply to message #156797] Sat, 28 January 2006 01:02 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
According to the SQL Reference Guide: "Specify REUSE to allow Oracle Database to overwrite any existing file called filename."

Best regards.

Frank

Report message to a moderator

Previous Topic: Index Space Utilization
Next Topic: index monitoring
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 25 10:53:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.