dbsnmp, outln and SAFE check script

Hi,

Following on from the SAFE check script kindly supplied by Laura.

Is it possible or advisable to move tables owned by the OUTLN user out of the system tablespace?

        I would imagine that they should stay there but interested in experience of others.

Is it possible or advisable to alter the DBSNMP and OUTLN users to have a temporary table space other than system?

        I read a Metalink forum posting suggesting it should be done but have others done this?

        Note that I have altered sys and system and to have a separate temporary tablespace.

Thanks,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au

-----Original Message-----
From: Burton, Laura L. [mailto:BurtonL_at_prismplus.com] Sent: Thursday, 16 November 2000 2:11
To: Multiple recipients of list ORACLE-L Subject: RE: Redo a Tablespace

It comes from an article 'How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation' by B. Himatsingka and J. Loaiza from the Oracle Corporation.
SAFE = Simple Algorithm for Fragmentation Elimination I made a script which contain queries for the rules referenced in the article. I'll send it to you if you want it. Received on Wed Nov 15 2000 - 16:15:53 CST