Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: exp owner=sys, system compress=y?
"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
![]() |
![]() |