eygle.com - 留言簿 - 回复留言

eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com

返回留言簿

回复留言

留言ID:

留言原文:

To: eygle
　　不好意思，贴错了！
错误应该是：
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE package APPS_ARRAY_DDL AUTHID DEFINER as"
"/* $Header: adaaddls.pls 115.2 1999/11/09 16:51:03 pkm ship $ */"
" --"
" -- Package"
" -- APPS_ARRAY_DDL"
" -- Purpose"
" -- Dynamic DDL support for large objects needing >32K SQL statements"
" -- Notes"
" -- 1. This package is created in each Oracle Applications account"
" -- 2. Each account requires the following explicit"
" --privileges to run (i.e. these privileges cannot be obtained"
" --from a role, like 'connect'):"
" --grant create session to <schema>;"
" --grant alter session to <schema>;"
" --grant create database link to <schema>;"
" --grant create synonym to <schema>;"
" --grant create view to <schema>;"
" --grant create cluster to <schema>;"
" -- grant create procedure to <schema>;"
" -- grant create sequence to <schema>;"
" -- grant create table to <schema>;"
" -- grant create trigger to <schema>;"
" -- Currently AutoInstall grants the neccessary privs to each schema"
" --"
"glprogtext dbms_sql.varchar2s;"
"procedure apps_array_ddl(lb in integer,"

事情是这样的：
开始我创建了用户之后，通过pl/sql developer软件，察看其他erp系统的inv用户的权限，发现只有：
grant alter any outline to INV;
grant alter session to INV;
grant analyze any to INV;
grant create any outline to INV;
grant create cluster to INV;
grant create database link to INV;
grant create sequence to INV;
grant create session to INV;
grant create snapshot to INV;
grant create table to INV;
grant create type to INV;
grant drop any outline to INV;
grant query rewrite to INV;
这些权限，而且我用这个inv创建package也没有问题，所以我在我的环境建好用户inv后，也执行了这行语句进行授权，然后进行倒入，但是错误就出现了，除非我把上面的错误提示中的授权脚本加上，为什么呢？
谢谢啦！

From: Remen
2005.07.19 22:29