DONE...!! special thanx for Mas Yoel & Mas Yopi...
----- Original Message ---- From: yopi setiawan <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, July 3, 2008 9:02:45 AM Subject: Re: [indo-oracle] need help..!! create table via script Coba di grant create any table regards yopz --- On Wed, 7/2/08, dony widiotomo <[EMAIL PROTECTED] com> wrote: From: dony widiotomo <[EMAIL PROTECTED] com> Subject: [indo-oracle] need help..!! create table via script To: indo-oracle@ yahoogroups. com Date: Wednesday, July 2, 2008, 6:45 PM Dear Oracle-ers.. . saya mau bikin table menggunakan procedure di dlm packages.. kurang lebih spt ini : create or replace package PKG_create_table is procedure sp_create_table; end PKG_create_table; / create or replace package body PKG_create_table is procedure sp_create_table as begin execute immediate 'create table tb_02 as select * from tb_01'; end; end PKG_create_table; tp saat di-execute muncul ora-01031 : insufficient privileges.. sedangkan saat script ini : begin execute immediate 'create table tb_02 as select * from tb_01'; end; saya execute secara manual, tabel bisa di-create dengan sukses.. knp ya..?? utk role privileges user db yg bersangkutan, sudah di grant utk 'dba' thanx before for your help... [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
