Hi All,
Am I the only paranoid DBA left??
We do not use the REUSE parameter because it is too easy to make a
typo and create massive overtime for yourself.
Example:
Tablespace SBLDATA alreadys exist and has datafile /ora01/SBL/SBTST_sbldata1.001
Desired SQL statement:
Create tablespace SBLDATA2 datafile '/ora01/SBL/SBTST_sbldata2.001' size 50M, reuse;
Create tablespace SBLDATA2 datafile '/ora01/SBL/SBTST_sbldata1.001' size 50M;
will fail
Create tablespace SBLDATA2 datafile '/ora01/SBL/SBTST_sbldata1.001' size 50M, reuse;
will succeed meaning you will be working late tonight!!!!!
Please forgive any syntax errors.
In a production scenario paranoia is a good thing :)
Dave
--
Dave Morgan
Senior Database Administrator
Internet Barter Inc.
www.bartertrust.com
Received on Thu Jun 22 2000 - 11:57:55 CDT
