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: Using DDL commands in PL/SQL

Re: Using DDL commands in PL/SQL

From: Rod Corderey <Lane_Associates_at_compuserve.com>
Date: Tue, 28 Apr 1998 14:18:36 +0100
Message-ID: <3545D72C.D5173F7E@compuserve.com>


Mikael,

has the user also got the necessary resource on the tablespace in which the table is being created?

regards,

Rod Corderey
Lane Associates
Lane_Associates_at_Compuserve.com
http://www.Lane-Associates.com

Mikael Schonenberg wrote:
>
> Through dbms_sql (in PL/SQL) I manage to use DDL commands, which is very
> nice. Problem is I don't manage all of them. Drop Table works fine, but
> when I try to Create Table it complaints about insufficient priviliges.
> Well, I found that somewhat hard to believe, since the user woning
> and running the PL/SQL package is granted the DBA role.
>
> Any idea?
>
> /Mikael
Received on Tue Apr 28 1998 - 08:18:36 CDT

Original text of this message

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