文章存档
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2007-03-14 17:51:26
create index salary_index on employees(salary)
indextype is position_indextype;
ora-29855: error occurred in the execution of odciindexcreate routine
ora-01031: insufficient privileges
ora-06512: at "usergan.type_name", line 1
static function odciindexcreate (ia sys.odciindexinfo, parms varchar2, env sys.odcienv) return number
is
stmt varchar2(2000);
begin
-- construct the sql statement
stmt := 'create table ' || ia.indexschema || '.' || ia.indexname ||
'_storage_tab' || '(col_val, base_rowid, constraint pk primary key ' ||
'(col_val, base_rowid)) organization index as select ' ||
ia.indexcols(1).colname || ', rowid from ' ||
ia.indexcols(1).tableschema || '.' || ia.indexcols(1).tablename;
execute immediate stmt;
return odciconst.success;
end;
the user i set it "connect, resource" privileges.
find more information about the error, i have not found it.
set the create user with dba privilege, and the also is error ora-01031.
the last time i find it, must set create any table privilege.
if you want learn more about indextype, see oracle document about "using extensible index", or use google find more.
indextype is position_indextype;
ora-29855: error occurred in the execution of odciindexcreate routine
ora-01031: insufficient privileges
ora-06512: at "usergan.type_name", line 1
static function odciindexcreate (ia sys.odciindexinfo, parms varchar2, env sys.odcienv) return number
is
stmt varchar2(2000);
begin
-- construct the sql statement
stmt := 'create table ' || ia.indexschema || '.' || ia.indexname ||
'_storage_tab' || '(col_val, base_rowid, constraint pk primary key ' ||
'(col_val, base_rowid)) organization index as select ' ||
ia.indexcols(1).colname || ', rowid from ' ||
ia.indexcols(1).tableschema || '.' || ia.indexcols(1).tablename;
execute immediate stmt;
return odciconst.success;
end;
the user i set it "connect, resource" privileges.
find more information about the error, i have not found it.
set the create user with dba privilege, and the also is error ora-01031.
the last time i find it, must set create any table privilege.
if you want learn more about indextype, see oracle document about "using extensible index", or use google find more.
给主人留下些什么吧！~~