jlandzpa
帖子太长了,要有耐心看啊。嘻嘻
好象是权限的问题。
SQL> desc ykkf.b_fault;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL VARCHAR2(20)
SLSJ DATE
QY_ID VARCHAR2(10)
YHH VARCHAR2(20)
BKH VARCHAR2(20)
BXDZ VARCHAR2(50)
CKDZ VARCHAR2(50)
BXDW VARCHAR2(50)
BXRXM VARCHAR2(10)
BXRDH VARCHAR2(30)
GZLX_ID VARCHAR2(10)
BYQGH VARCHAR2(10)
CBGZXZ_ID VARCHAR2(10)
GZQK VARCHAR2(255)
SLRY VARCHAR2(10) SFDF VARCHAR2(10)
DFSJ DATE
JSRXM VARCHAR2(10)
DFRY VARCHAR2(10)
MYD_ID VARCHAR2(10)
YHYJ VARCHAR2(200)
FSBM_ID VARCHAR2(10)
DQBM_ID VARCHAR2(10)
ZT_ID VARCHAR2(10)
YHBM VARCHAR2(20)
HRDH VARCHAR2(20)
SFHF VARCHAR2(10)
SFDB VARCHAR2(10)
DQWCSJ DATE
HFBZ VARCHAR2(100)
SJ VARCHAR2(20)
HFSJ DATE
YWLY VARCHAR2(10)
DWSJ DATE
SFASDD VARCHAR2(10)
DDSX VARCHAR2(4)
CFCS VARCHAR2(10)
ykkf模式的权限是DBA WITH ADMIN
grant execute on SYS.DBMSOBJGWRAPPER to YKKF;
grant execute on SYS.DBMS_DEFER_INTERNAL_QUERY to YKKF;
grant execute on SYS.DBMS_DEFER_INTERNAL_SYS to YKKF;
grant execute on SYS.DBMS_DEFER_QUERY to YKKF;
grant execute on SYS.DBMS_DEFER_SYS to YKKF;
grant execute on SYS.DBMS_INTERNAL_REPCAT to YKKF;
grant execute on SYS.DBMS_OFFLINE_OG to YKKF;
grant execute on SYS.DBMS_OFFLINE_SNAPSHOT to YKKF;
grant execute on SYS.DBMS_RECTIFIER_DIFF to YKKF;
grant execute on SYS.DBMS_REPCAT to YKKF;
grant execute on SYS.DBMS_REPCAT_DECL to YKKF;
grant execute on SYS.DBMS_REPCAT_RGT to YKKF;
grant execute on SYS.DBMS_REPCAT_RPC to YKKF;
grant execute on SYS.DBMS_REPCAT_UNTRUSTED to YKKF;
grant execute on SYS.DBMS_REPCAT_UTL to YKKF;
grant execute on SYS.DBMS_SNAPSHOT to YKKF;
grant execute on SYS.DBMS_SNAP_REPAPI to YKKF;
grant select on SYS.DEFLOB to YKKF;
grant select on SYSTEM.DEF$_LOB to YKKF;
-- Grant/Revoke role privileges
grant connect to YKKF with admin option;
grant dba to YKKF with admin option;
grant exp_full_database to YKKF with admin option;
grant imp_full_database to YKKF with admin option;
grant resource to YKKF with admin option;
grant select_catalog_role to YKKF;
-- Grant/Revoke system privileges
grant alter any cluster to YKKF;
grant alter any index to YKKF;
grant alter any procedure to YKKF;
grant alter any sequence to YKKF;
grant alter any snapshot to YKKF;
grant alter any table to YKKF;
grant alter any trigger to YKKF;
grant alter any type to YKKF;
grant alter session to YKKF;
grant comment any table to YKKF;
grant create any cluster to YKKF;
grant create any index to YKKF;
grant create any indextype to YKKF;
grant create any operator to YKKF;
grant create any procedure to YKKF;
grant create any sequence to YKKF;
grant create any snapshot to YKKF;
grant create any synonym to YKKF;
grant create any table to YKKF;
grant create any trigger to YKKF;
grant create any type to YKKF;
grant create any view to YKKF;
grant create database link to YKKF;
grant create procedure to YKKF;
grant create public synonym to YKKF;
grant create session to YKKF;
grant delete any table to YKKF;
grant drop any cluster to YKKF;
grant drop any index to YKKF;
grant drop any indextype to YKKF;
grant drop any operator to YKKF;
grant drop any procedure to YKKF;
grant drop any sequence to YKKF;
grant drop any snapshot to YKKF;
grant drop any synonym to YKKF;
grant drop any table to YKKF;
grant drop any trigger to YKKF;
grant drop any type to YKKF;
grant drop any view to YKKF;
grant drop public synonym to YKKF;
grant execute any procedure to YKKF;
grant insert any table to YKKF;
grant lock any table to YKKF;
grant select any dictionary to YKKF;
grant select any table to YKKF;
grant unlimited tablespace to YKKF with admin option;
grant update any table to YKKF;