Home » RDBMS Server » Server Administration » Tablespace quotas and creation of tables
Tablespace quotas and creation of tables [message #369402] Wed, 13 September 2000 16:22 Go to next message
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
Re: Tablespace quotas and creation of tables [message #369404 is a reply to message #369402] Thu, 14 September 2000 10:05 Go to previous messageGo to next message
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
Re: Tablespace quotas and creation of tables [message #369450 is a reply to message #369402] Sat, 23 September 2000 15:22 Go to previous messageGo to next message
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.
Re: Tablespace quotas and creation of tables [message #369477 is a reply to message #369450] Fri, 29 September 2000 06:08 Go to previous messageGo to next message
Reddy
Messages: 11
Registered: September 2000
Junior Member
see, when u r creating tables they are assigned default tablespace.
so thats the reason.

reddy
Re: Tablespace quotas and creation of tables [message #369478 is a reply to message #369477] Fri, 29 September 2000 07:07 Go to previous message
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.
Previous Topic: Oralce-shutting down automatically
Next Topic: lookin for some test papers for OCP exams
Goto Forum:
  


Current Time: Thu Mar 28 04:47:04 CDT 2024