On Wed, 25 Jun 2003 23:05:47 +0200, Sybrand Bakker
<gooiditweg (AT) sybrandb (DOT) demon.nl> wrote:

Truly, I have read the manual thoroughly, not just skimmed through it.
If I need to take a course I do not have to pay for it, but there is
no need for me to take it now because I am doing it on the job.

Thanks

Which is why I always create users with zero quota on system.
Saves this sort of trouble and avaoids IMPort problems later in life.

Cheers,
Norm.


-----Original Message-----
From: oratune (AT) msn (DOT) com (David Fitzjarrell) [mailtoratune (AT) msn (DOT) com]
Posted At: Wednesday, June 25, 2003 5:53 PM
Posted To: server
Conversation: Default tablespace for a suer
Subject: Re: Default tablespace for a suer


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

David Fitzjarrell

I think all quotas are zero by default, if not explicitly set when creating
a user.
The real problem is, that lot of people still use connect and resource
roles, which they grant to all users.
The resource role has unlimited tablespace privilege and thats why you got
lots of crap in system ts.

Tanel.

Morning Tanel,


required privs are granted to the role - connect, resourcse and dba are
granted to no-one !


Importing does this :

1. Place objects in the tablespace they came from - if that is available
and the user has quota.

2. If (1) fails, place objects in users own default tablespace -
assuming quota is available.

3. If (2) fails (because user has NO quota in default tablespace) then
use SYSTEM.


Note, this was true at version 7 when I first did dba and backup &
recovery courses. I have come a cropper with this in the past, but I
have not tested the 'theory' on 8i and 9i databases. It is also more
likely to occur if the import is being done by a dba user.

If I get time soon, I'll have a test and see what occurs.


Cheers,
Norman.

--
-----------------------------------------------------------------
Norman Dunbar (at home on Linux)
Oracle (AT) mssqlBountifulSolutions (DOT) co.uk

(Delete a Microsoft database name to reply - clue, mssql !)
-----------------------------------------------------------------