Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE/PLSQL: ORA-04091

gkayaDec 28 2015 — edited Dec 28 2015

Hi all,

I have a package that include a procedure. I'm using this procedure for inserting data to ps_acu_sf_tahs table if provide some conditions. But when I try to run as bellow:

begin

tahs_aktarim_.tahs_aktarim('45397','T1' );

end;

I m getting error: ORA-04091

I checked out all triggers that if effect ps_acu_sf_tahs table but there is no trigger which effect that table.


I just curious about what is the problem if there is no trigger for that table.

Is there anyone who faced similar weird problem?

Regards,

Gunce
This post has been answered by Paulzip on Dec 28 2015
Jump to Answer

Comments

Tubby
Drop index un1 ;
create index un1 on xx_test (a1,a2,a3) ;
586651
I dont want to drop the index is it possible to alter?
659537
yes you can alter index with "alter index" syntax to change.
You can alter index for :-
Rebuild or coalesce an existing index
Deallocate unused space or allocate a new extent
Specify parallel execution (or not) and alter the degree of parallelism
Alter storage parameters or physical attributes
Specify LOGGING or NOLOGGING
Enable or disable key compression
Mark the index unusable
Start or stop the monitoring of index usage

-----You cannot alter an index's column structure.---------

For more details check in the documentation
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/indexes.htm#518
659537
yes you can alter index with "alter index" syntax to change.
You can alter index for :-
Rebuild or coalesce an existing index
Deallocate unused space or allocate a new extent
Specify parallel execution (or not) and alter the degree of parallelism
Alter storage parameters or physical attributes
Specify LOGGING or NOLOGGING
Enable or disable key compression
Mark the index unusable
Start or stop the monitoring of index usage

-----You cannot alter an index's column structure.---------

For more details check in the documentation
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/indexes.htm#518
Karthick2003
[ALTER INDEX|http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_1008.htm#SQLRF00805] is beautifully documented.

Thanks,
Karthick.
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 25 2016
Added on Dec 28 2015
#plsql, #trigger
14 comments
2,886 views