Some thoughts gleaned from my years of Oracle Database Administration experience (version 5 through 12c). Primarily focused on Unix/Linux OS's, dealing with Very Large Databases (multi-terabyte). Some tables in excess of 700 gigabytes, ASM, RAC, and a lot of other fun things. I might even add some thoughts about third party Campaign Tools, such as Unica which I use to support. Who knows where we might end up.
Monday, June 12, 2006
Including Datafiles
Here is a nice little feature that works in Oracle 10g.
drop tablespace including contents and datafiles.
Oh I love that; all is cleaned up in one easy statement.
No comments:
Post a Comment