I wanted to begin all my GoldenGate configurations as new setup. So I have disabled ddl support and removed marker. Then I have dropped all GG schema tables but one table named GGS_STICK is returned error “ERROR at line 1:
ORA-14452: attempt to create, alter or drop an index on temporary table already in use

So here is a solution to solve the error.

Find out which sessions locking the table:

Many rows are returned. So some scripting to kill the sessions.

Now we can drop the table.

Enjoy ūüôā

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply