Re: What's wrong with this query (SQLPlus aborts on me)?

hi Simon ,

Please check if you have a temporary tablespace and the user that try to activate the query have that temporary tablespace.

Bye Lior.

Simon Goland <sg_at_mda.ca> wrote in article <32D280FC.47C5_at_mda.ca>...
> Something that seems very simple to me - just trying to find all the
> tables and the privileges the roles/users have. The query is:
>
> SELECT r.granted_role,
> r.grantee,
> t.table_name,
> t.privilege
> FROM dba_role_privs r,
> dba_tab_privs t
> WHERE r.grantee = t.grantee
> ORDER BY r.granted_role, r.grantee, t.table_name;
>
> When I run it, nothing happens for several seconds, and then I am kicked
> out of SQLPLus to Unix prompt. No error messages, except for a
> suspicious ORA-07445 in the alert log (is it related?). It does run OK
> when I restrict the scope of the query with
> the addition of 'AND r.grantee = <some specific user>' to the WHERE
> clause.
>
> Do I need to increase some buffer/memory space somewhere for that? I am
> running it on 7.3.2.1.0 as SYSTEM.
>
> Thanks,
> --
> [ Simon Goland sg_at_mda.ca ]
> [ B-)> ]
> [ Without action there is no change ]
>
  Received on Tue Jan 07 1997 - 00:00:00 CST