OraFAQ Forum: Server Administration » Tablespace quotas and creation of tables

Home » RDBMS Server » Server Administration » Tablespace quotas and creation of tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tablespace quotas and creation of tables [message #369402]

Wed, 13 September 2000 16:22

tinku
Messages: 5
Registered: August 2000

Junior Member

Hi,

I am creating a new user in ORACLE8 database using the SQL "Create user user1 identified by user1 default tablespace tabsp1";

I am not giving any quota for any tablespace. However I am able to create table in "user1" schema
and also insert rows into it. At the same time the dba_ts_quotas contains no rows for user "user1".

Can someone please explain where my understanding is going wrong.

Thanks in advance

Regards
Tinku

Report message to a moderator

Re: Tablespace quotas and creation of tables [message #369404 is a reply to message #369402]

Thu, 14 September 2000 10:05

Salman Khan
Messages: 51
Registered: September 2000

Member

Hi,

The reason is not showing you in dbs_ts_quota because you did'nt any quota limit for this user

if you issue this statement you will see the entry in dba_ts_quota

ALTER USER user1 QUOTA 2M ON user_tablespace;

Bye
SK

Report message to a moderator

Re: Tablespace quotas and creation of tables [message #369450 is a reply to message #369402]

Sat, 23 September 2000 15:22

tinku
Messages: 5
Registered: August 2000

Junior Member

Hi,

My doubt is that why I am able to create any tables and also insert rows when I have not assigned any quota to the user.

Report message to a moderator

Re: Tablespace quotas and creation of tables [message #369477 is a reply to message #369450]

Fri, 29 September 2000 06:08

Reddy
Messages: 11
Registered: September 2000

Junior Member

see, when u r creating tables they are assigned default tablespace.
so thats the reason.

reddy

Report message to a moderator

Re: Tablespace quotas and creation of tables [message #369478 is a reply to message #369477]

Fri, 29 September 2000 07:07

tinku
Messages: 5
Registered: August 2000

Junior Member

Well I think I am not able to put my message across: My doubt is that the new user that I have created has no quotas on any tablespace whatsoever; so how is it that tables are being allowed to be created in the user's schema.

Report message to a moderator

Previous Topic:	Oralce-shutting down automatically
Next Topic:	lookin for some test papers for OCP exams

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 11:38:14 CST 2024