Suppose you create a user and no default tablespace and no temporary
tablespace are specified for the user.
The DB does have a default tablespace and a default temporary
tablespace.
Where will the user's objects be stored?
Where will the user's sort segments be stores?

Thanks

create user grandmother identified by suckeggs;
select default_tablespace,temporary_tablespace from user_users
where username='GRANDMOTHER';


--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Peter" <peter (AT) nomorenewsspammin (DOT) ca> wrote

"Niall Litchfield" <n-litchfield (AT) audit-commission (DOT) gov.uk> wrote


And the winner is ... SYSTEM TABLESPACE!

Dusan

Dusan Bolek wrote:

Actually - it depends!

Latest versions allow system wide defaults - and the OP did specify that these were set.

That should show you that SYSTEM is the default tablespace and the
temporary tablespace ... a scary proposition.

David Fitzjarrell

"Niall Litchfield" <n-litchfield (AT) audit-commission (DOT) gov.uk> wrote

On Wed, 25 Jun 2003 10:15:02 GMT, Peter <peter (AT) nomorenewsspammin (DOT) ca>
wrote:

Why do you keep asking questions which can be readily answered by
*READING* the documentation, as opposed to just LOOKING at it, like
you do?
Why do you insist on being such an annoying bore?
Are you by accident preparing for OCP and do you want to get all the
correct answers from this group?
GO AWAY, go bore some other forum


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

No, I don't think there's a system wide default for data tablespaces. Only
for temp.

In PROPS$ there is only DEFAULT_TEMP_TABLESPACE record, nothing for data.
The syntax also supports setting default temp ts. The winner is system.


SQL> select value$ from props$ where name like 'DEFAULT%';

VALUE$
----------------------------------------------------------
TEMP

SQL> create user x identified by x;

User created.

SQL> select default_tablespace, temporary_tablespace from dba_users where
username = 'X';

DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
------------------------------ ------------------------------
SYSTEM TEMP

Tanel.

"Hans Forbrich" <forbrich (AT) telusplanet (DOT) net> wrote

There is only one for the default temp tablespace. If you look at the
docs
(http://download-west.oracle.com/docs...a.htm#2079107),
you will see how to set a default temporary tablespace, but there is no
mention of how to set the default data tablespace.

HTH,
Brian

Tanel Poder wrote:
--
================================================== =================

Brian Peasland
oracle_dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

On Wed, 25 Jun 2003 19:09:41 +0200, Sybrand Bakker
<gooiditweg (AT) sybrandb (DOT) demon.nl> wrote:

I just want to stimulate discussions here. Reading the manual is nice
but not as intelluectually stimulating as discussing openly here.
Like I said before, I have read the manual several times.

Thanks

On Wed, 25 Jun 2003 20:52:10 GMT, Peter <peter (AT) nomorenewsspammin (DOT) ca>
wrote:

You have *LOOKED* at it, you didn't read it. And you don't
'stimulate', you just *BORE* and *ANNOY*
You don't want to pay for a course, so you decided to *misuse* this
group



Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address