How make rollback segment online/offline in plsql procudure ?

[avion1]

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

[davey23uk]

the user dware doesnt have permission to alter a rollback segment

[dbasan]

What's the purpose to do that from pl/sql?

[avion1]

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

[avion1]

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