Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: exp owner=sys, system compress=y?

Re: exp owner=sys, system compress=y?

From: frank <fbortel_at_home.nl>
Date: Tue, 03 Oct 2000 18:16:46 GMT
Message-ID: <39DA20A7.94CF55FA@home.nl>

"Howard J. Rogers" wrote:

> <snipped>
> And it remains true that I've never encountered any problems from setting
> pctincrease to the otherwise generally recommnded figure of zero. Whatever
> the scripts say. (Remember, these are the same scripts that give you, for
> example, users SYSTEM and SYS with SYSTEM tablespace as their temp
> tablespace!!)
>
> Regards
> HJR
>

Check'm out - the script now generated by the DB Wizard actually assigns a temporary temp tablespace to SYS and SYSTEM, much to my surprise!

<snipped>
And yes, I was in this situation once, on 7.2 where a Designer/2000 repository was implemented. Because of the many packages, I had the habit of setting pct inc on system TS to 0 - it speeded up repository creation. After being in production for a while, we were confronted with a pretty harmless

'Max extents reached' - on the system TS, and the system came to a grinding halt. Received on Tue Oct 03 2000 - 13:16:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US