I am using liferay and many times I see the error stating index name or constraint names SYS_C00381400 or IX_C7057FF7. But don’t know how to find the actual table impacted so that I can fix it.
Post your questions and share knowledge, Hopefully you will gain something of significance here
I am using liferay and many times I see the error stating index name or constraint names SYS_C00381400 or IX_C7057FF7. But don’t know how to find the actual table impacted so that I can fix it.
You can use SQLs like:
select * from all_constraints where owner = 'SCHEMA_ONWER_NAME' and constraint_name = 'SYS_C00381400';select * from all_indexes where owner='SCHEMA_OWNER_NAME' and index_name='IX_C7057FF7';