Re: SYSTEM's default and temp tablespace

James,

Allways use a non-system tablespace for temporary segments! If SYSTEM should own objects it is good practice to place these outside the system tablespace as well.

I would recommend the TOOLS/TEMP approach.

Cheers,
Jesper

On Mon, 19 Jun 2000 14:04:23 GMT, James Hanway <hanwayj_at_mar.dfo-mpo.gc.ca> wrote:

>Morning all,
>
>Whats the general rule for the SYSTEM account's default/temporay
>tablespaces?
>
>I've always thought *both* should be set to the SYSTEM tablespace, but I
>have seen a number of other setups like: SYSTEM/TEMP, TOOLS/TEMP, etc.
>Is SYSTEM/SYSTEM the generally accepted defualt/temporary tablespace
>setup?
>
>Cheers!
>
>James
Received on Mon Jun 19 2000 - 00:00:00 CDT