Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: O8: No Privileges on tablespace "XYZ"
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
![]() |
![]() |