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: Mark D Powell <markp7832_at_my-deja.com>
Date: 2000/07/03
Message-ID: <8jq6aq$hne$1@nnrp1.deja.com>#1/1

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