| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql rollback segs
A copy of this was sent to Lane Hignight <lhignight_at_otaywater.gov>
(if that email address didn't require changing)
On Tue, 26 May 1998 09:40:59 -0700, you wrote:
>Anyone have an example of pl/sql code which gets the status of a
>rollback segment, then brings it online if it's not already online?
>I've tried the code below, but I get errors when referencing
>sys.dba_rollback_segs..
>
roles are never enabled during the execution of a procedure.
Try this:
SQL> set role none;
SQL> "statement you want to test to see if it'll work in a procedure"
If you can do it in plus with no roles you can do it in a procedure. If you can't, you must have the privelege from a role and hence dbms_sql won't be able to do it either.
You probably have the privelege to do what you are trying to do in dbms_sql via a role. Grant the privelege directly to the owner of the procedure and it'll work.
>Thanks - Lane
.. snip..
>END; -- Procedure
>------------------------------------------------------------------
>Error
>(1):PLS-00201: identifier 'SYS.DBA_ROLLBACK_SEGS' must be declared
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue May 26 1998 - 12:24:18 CDT
 |
 |