tpc reports, does anyone read them?

From: bdbafh <>
Date: Fri, 11 Apr 2008 12:11:04 -0700 (PDT)
Message-ID: <> Page 96

spool createmisc.log
set echo on;
alter user tpcc temporary tablespace system;

So ... when is the last release in which a user account could have a temporary tablespace that was system?
I'm quite certain that it pre-dated 8i.

One explanation is that no one ever reviews the log files that are generated ... even though an auditor signs off on the report.

Yeah, the statement simply fails and the user's temporary tablespace remains unchanged.
No big deal.
It just seems to me that they likely haven't reviewed their scripts since they outsourced their dba operations prior to moving to 8i.

-bdbafh Received on Fri Apr 11 2008 - 14:11:04 CDT

Original text of this message