日历

2012年九月
« 6月   10月 »
 12
3456789
10111213141516
17181920212223
24252627282930

最近评论

    ORACLE

    SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled

    SQL> conn lxy/lxy

    SQL> set autot on stat;
    SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled
    SP2-0611: Error enabling STATISTICS report

    SQL> cgrant plustrace to lxy ;
    grant plustrace to lxy
    *
    ERROR at line 1:
    ORA-01919: role ‘PLUSTRACE’ does not exist 角色不存在

    SQL> @/u01/oracle/sqlplus/admin/plustrce.sql  运行这个sql

    SQL> grant plustrace to lxy;

    Grant succeeded. 这样分配就可以了

    SQL> conn lxy/lxy
    Connected.
    SQL> set autot on stat
    SQL> select count(*) from […]

    ORACLE

    ORA-01950: no privileges on tablespace 'USERS'错误解决方法

    SQL> create user lxy identified by lxy default tablespace users;

    User created.

    SQL> grant create session,alter session,create table,create view,
    2  create synonym,create cluster,create database link,create sequence,
    3  create trigger,create type,create procedure,create operator to lxy;

    Grant succeeded.

    SQL> conn lxy/lxy
    Connected.
    SQL> create table m(id integer,name char(10));
    create table m(id integer,name char(10))
    *
    ERROR at line 1:
    ORA-01950: no privileges on tablespace ‘USERS’

    上面错误的解决方法是在创建用户分配权限后,执行下面的语句:

    SQL> alter user lxy quota 10M […]