SQL> create or replace procedure fxb as
2 begin
3 execute immediate 'analyze table xxfl estimate statistics sample 30 percent';
4 execute immediate 'analyze table tpxx estimate statistics sample 30 percent';
5 ctx_ddl.sync_index('INX_CUSTOMINFO_ADDR_DOCS');
6 ctx_ddl.optimize_index('INX_CUSTOMINFO_ADDR_DOCS', 'FAST');
7 end;
8 /警告: 创建的过程带有编译错误。为什么会有编译错误,请教各位
2 begin
3 execute immediate 'analyze table xxfl estimate statistics sample 30 percent';
4 execute immediate 'analyze table tpxx estimate statistics sample 30 percent';
5 ctx_ddl.sync_index('INX_CUSTOMINFO_ADDR_DOCS');
6 ctx_ddl.optimize_index('INX_CUSTOMINFO_ADDR_DOCS', 'FAST');
7 end;
8 /警告: 创建的过程带有编译错误。为什么会有编译错误,请教各位
begin
execute immediate 'analyze table xxfl estimate statistics sample 30 percent';
execute immediate 'analyze table tpxx estimate statistics sample 30 percent';
execute immediate 'ctx_ddl.sync_index(''INX_CUSTOMINFO_ADDR_DOCS'')';
execute immediate 'ctx_ddl.optimize_index(''INX_CUSTOMINFO_ADDR_DOCS'', ''FAST'')';
end;
/
begin
execute immediate 'analyze table xxfl estimate statistics sample 30 percent';
execute immediate 'analyze table tpxx estimate statistics sample 30 percent';
ctx_ddl.sync_index('INX_CUSTOMINFO_ADDR_DOCS');
ctx_ddl.optimize_index('INX_CUSTOMINFO_ADDR_DOCS', 'FAST');
exception
when others then
rollback;
end fxb;
/
BEGIN fxb; END;*
ERROR 位于第 1 行:
ORA-00900: 无效 SQL 语句
ORA-06512: 在"LICHENG.FXB", line 5
ORA-06512: 在line 1这是怎么回事??
2 begin
3 execute immediate 'analyze table xxfl estimate statistics sample 30 percen';
4 execute immediate 'analyze table tpxx estimate statistics sample 30 percen';
5 execute immediate 'ctx_ddl.sync_index(''INX_CUSTOMINFO_ADDR_DOCS'')';
6 execute immediate 'ctx_ddl.optimize_index(''INX_CUSTOMINFO_ADDR_DOCS'', ''
AST'')';
7 end;
8 /过程已创建。
2 begin
3 execute immediate 'analyze table xxfl estimate statistics sample 30 percent';
4 execute immediate 'analyze table tpxx estimate statistics sample 30 percent';
5 execute immediate 'ctx_ddl.sync_index(''INX_CUSTOMINFO_ADDR_DOCS'')';
6 execute immediate 'ctx_ddl.optimize_index(''INX_CUSTOMINFO_ADDR_DOCS'', ''FAST'')';
7 end;
8 /过程已创建。