-
How make rollback segment online/offline in plsql procudure ?
Hi All,
I like to small rollback segments from a plsql procedure. whem I execute the following command in the procedure
EXECUTE IMMEDIATE 'alter rollback segment rbs7 online';
I am getting the following error:
ORA-01031: insufficient privileges
ORA-01031: insufficient privileges
ORA-06512: at "DWARE.PR_ROLLBACK_ONLINE", line 16
Please advice.
Thanks
-
the user dware doesnt have permission to alter a rollback segment
-
What's the purpose to do that from pl/sql?
-
Originally Posted by dbasan
What's the purpose to do that from pl/sql?
We are trying to make some rollback segment offline and some online. e.g. we are trying to offline all small segments and big segment online from a procedure.
Cheers
-
Originally Posted by davey23uk
the user dware doesnt have permission to alter a rollback segment
Thanks,
I gave GRANT ALTER ROLLBACK SEGMENT TO DWARE; and it is working.
Cheers
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|