[askdba] Re: Why its not creating table

  • From: "Patricia Eyenga" <patricia.e@xxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>, <askdba@xxxxxxxxxxxxx>
  • Date: Wed, 15 Dec 2004 05:34:58 -0700

make sure the user has either quota unlimited on that tablespace, or at least 
enough to accomodate the size of the table.

Patricia Eyenga
On-Pointe Database Services Co.
Tel: 202-327-0877
Fax: 301-552-2290
Web: http://www.odsc.net
Email: patricia.e@xxxxxxxx 

 From: sanjay.khangarot@xxxxxxxxx
Sent: Tuesday, December 14, 2004 11:42 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Why its not creating table 

can you post the actual error... It seems the users does not have quota on=
the tablespace to create the object..

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]On
Behalf Of drumil narayan
Sent: Wednesday, December 15, 2004 11:48 AM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Why its not creating table

Dear All,

I created user, given him connect, create session,
create any table privs.

and tried to create a table, it gave me the error as
insuffcient privs for creating the table in
i checked the default tablespace of the user it was
the same as mentioned in error..
then i assigned him dba privs, then it was able to
create the table..

even i dropped the user twice...still the error

can somebody point me what is the error, i do not want
to give the user dba privs, but he should be able to
create table..

what should i do..


Yahoo! India Matrimony: Find your life partner online
Go to: http://yahoo.shaadi.com/india-matrimony

Confidentiality Notice=0D

The information contained in this electronic message and any attachments to=
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or=
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or=
Mailadmin@xxxxxxxxx immediately
and destroy all copies of this message and any attachments.

Other related posts: