2014-07-09-third-terminal.txt

admin

[root@station90 ~]# su - oracle
[oracle@station90 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 9 19:19:10 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn /
Connected.
SQL> select count(*) from sh.sales;
select count(*) from sh.sales
                        *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> /

  COUNT(*)
----------
    918843

SQL> /

  COUNT(*)
----------
    918843

SQL> /
select count(*) from sh.sales
                        *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> /
select count(*) from sh.sales
                        *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> /

  COUNT(*)
----------
    918843

SQL> select count(*) from sh.sales;
select count(*) from sh.sales
                        *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> /
select count(*) from sh.sales
                        *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select  * from session_roles;

ROLE
------------------------------
CONNECT

SQL> conn  /
Connected.
SQL> select  * from session_roles;

ROLE
------------------------------
CONNECT
R1

SQL> select count(*) from sh.sales;

  COUNT(*)
----------
    918843

SQL> conn /
Connected.
SQL> select count(*) from sh.sales;

  COUNT(*)
----------
    918843

SQL> select count(*) from sh.sales;
select count(*) from sh.sales
                        *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select count(*) from sh.customers;

  COUNT(*)
----------
     55500

SQL> select count(*) from sh.customers;
select count(*) from sh.customers
                        *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select count(*) from sh.channels;
select count(*) from sh.channels
                        *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> /
select count(*) from sh.channels
                        *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select  * from session_roles;

ROLE
------------------------------
CONNECT
R1

SQL> set role CONNECT,R1;

Role set.

SQL> select  * from session_roles;

ROLE
------------------------------
CONNECT
R1
R2

SQL> select count(*) from sh.channels;

  COUNT(*)
----------
     5

SQL> select  * from session_roles;

ROLE
------------------------------
CONNECT
R1
R2

SQL> /

ROLE
------------------------------
CONNECT
R1
R2

SQL>





SQL>