Re: Sort Space

Kevin,
The tablespace that a user places anything they create is defined when you = create the user"
Create user xxx id'd by xx DEFAULT TABLESPACE zzzz TEMPORARY TABLESPACEccc"=

The default tablespace clause does that for you. Remember that if the = clause is NOT defined it will use the SYSTEM tablespace.  To have the user use a different tablespace "ALTER USER yadi, yadi, blah" =  Read the allowable options for the command in your manuals and you will = get the idea.
ROR m=AA=BF=AAm

>>> KNaik_at_mail.sbic.co.za 01/05/01 05:30AM >>>
Hi All,

Can anyone tell me, when I run a statement such as:

create table dummy2
as select * from dummy1

lets say the table has -+500 thousand records, why does this statement use the default tablespace for temporary work and NOT the temporary tablespace defined for the user ?

Kevin N

Disclaimer and confidentiality note

Everything in this e-mail and any attachments relating to the official = business of Standard Bank Investment Corporation (Stanbic) is proprietary to the company. It is confidential, legally privileged and = protected by law.\
Stanbic does not own and endorse any other content. Views and opinions are = those of the sender unless clearly stated as being that of Stanbic.=20

The person addressed in the e-mail is the sole authorised recipient.=20 Please notify the sender immediately if it has unintentionally reached you = and do not read, disclose or use the content in any way.

Stanbic can not assure that the integrity of this communication has been = maintained=20
nor that it is free of errors, virus, interception or interference.