RE: dbsnmp, outln and SAFE check script

Bruce,
  Yes, it is possible and, in fact, advisable to alter DBSNMP and OUTLN temp tablespace to something other than SYSTEM, and yes, I have done it.

  Yes, you can move OUTLN user's default tablespace. Something like this:
## ##############################
## export the user's objects

        EXP OUTLN/OUTLN ...
## remove the tables

	DROP TABLE OL$;
	DROP TABLE OL$HINTS;
	CREATE TABLESPACE outln_ts DATAFILE 'outln-tablespace-name.dbf' SIZE

        ALTER USER OUTLN DEFAULT TABLESPCACE outln_ts;
## import the user's objects

        IMP OUTLN/OUTLN ...
## ##############################

• Donna

-----Original Message-----
From: Reardon, Bruce (CALBBAY)
[mailto:Bruce.Reardon_at_comalco.riotinto.com.au] Sent: Wednesday, November 15, 2000 2:21 PM To: Multiple recipients of list ORACLE-L Subject: 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

The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on:

+44 (0)1753 534655, or email 'is_at_celltech.co.uk'

Celltech Group plc
216 Bath Road, Slough, SL1 4EN, Berkshire, UK

Registered Office as above. Registered in England No. 2159282 Received on Wed Nov 15 2000 - 18:51:20 CST