Database Administration - Tablespace Quota

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 203 of 226

Tablespace Quota

A user has connect and resource privileges allocated by the DBA. He is been allocated quota on three tablespaces by the DBA
- Default Tablespace Quota 500 M
- Tablespace 1 Quota 100 M
- Tablespace 2 Quota 200 M
Now the user tries to make a table which uses 300 M in tablespace 2. Will he be successful?

Total Answers and Comments: 4

Last Update: September 17, 2008 Asked by: shanthiavari

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 18, 2008 19:04:10

kollati

Member Since: July 2008 Contribution: 3

RE: Tablespace Quota

no, he will get error

Is this answer useful? Yes | No

July 21, 2008 12:17:06

vishnusivathej

Member Since: July 2008 Contribution: 3

RE: Tablespace Quota

i dont think there will be any error instead the user has resource privilege which gives unlimited access to tablespaces.. here resource privilege takes precedence..

Is this answer useful? Yes | No

July 21, 2008 12:19:58

vishnusivathej

Member Since: July 2008 Contribution: 3

RE: Tablespace Quota

there will be no such thing as default size for a tablespace u have to assign it when it is being created..
and more over by default u can have 100 datafiles in a database which is the default value used during the database creation process u can also change this value..

Is this answer useful? Yes | No

September 17, 2008 02:53:34

bassem_farouk

Member Since: September 2008 Contribution: 3

RE: Tablespace Quota

Yes he will be successful. because resource role grant user unlimited tablespace system privilege. quota ignored.

SQL> create user test identified by test1;

User created.

SQL> grant connect, resource to test;

Grant succeeded.

SQL> select * from dba_sys_privs where grantee='TEST'

GRANTEE PRIVILEGE ADMIN_

---------- -------------------- ------

TEST UNLIMITED TABLESPACE NO

Is this answer useful? Yes | No

Go To Top