Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: O8: No Privileges on tablespace "XYZ"

Re: O8: No Privileges on tablespace "XYZ"

From: Christopher Burke <craznar_at_hotmail.com>
Date: 2000/07/03
Message-ID: <8F67554F1chrisburkemailboxuqe@130.102.2.1>#1/1

I am sure it is the correct user I have given quota's to.

markp7832_at_my-deja.com (Mark D Powell) wrote in <8jq6aq$hne$1 @nnrp1.deja.com>:

>In article <8F66BF8BBchrisburkemailboxuqe_at_130.102.2.1>,
> craznar_at_hotmail.com (Christopher Burke) wrote:
>> I am logged in as a SYSDBA, and I get the above error when I Try to
 create
>> a table.
>>
>> I have given unlimited space to the user on XYZ and TEMP tablespaces.
>>
>> What am I missing.
>>
>Have you verified that the owner of the table has create table
>privilege and has quota on the target tablespace via
>sys.dba_ts_quotas? Sometimes when we think we did something it was to
>a different user, in a different instance, or we missed the error
>message due to a typo etc....
>--
>Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
>
Received on Mon Jul 03 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US