cangos

摘要： sys@ORCL> grant select on v$timer to test;grant select on v$timer to test *ERROR at line 1:ORA-02030: can only select from fixed tables/views分析：对以v$开头的视图，不能直接grantv$开头的视图是v_$的同义词如v$timer是v_$timer的同义词sys@ORCL> grant select on v_$timer to test;Grant succeeded. 阅读全文

摘要： 1、创建login脚本，将linesize、seerveroutput等进行统一设置define _editor=vi set serveroutput on size 1000000 set trimspool on set long 5000 set linesize 100 set pagesize 9999column plan_plus_exp format a80 column golbal_name new_value gname set termout off define gname=idle column global_name new_value gname select 阅读全文