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: tablespaces & schemas

Re: tablespaces & schemas

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sun, 17 Apr 2005 21:36:44 GMT
Message-ID: <Xns963B94A54F519SunnySD@68.6.19.6>


"gaddoz" <mynickname_at_gmail.com> wrote in news:4iz8e.792134$b5.35210670_at_news3.tin.it:

> Hi all,
> I'm getting ORA-01950 error, when I try to create a table with sys
> user in the tablespace users.
> The sys user have unlimited tablespace system privilege granted... so
> why sys can't use tablespace users?
>

You REALLY should NOT be using the user SYS for anything other than installing or manipulating Oracle approved objects. Received on Sun Apr 17 2005 - 16:36:44 CDT

Original text of this message

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