Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Technology Stack - EBS (MOSC)

Unable to Describe Tables in 19c Database

Apr 5, 2024 5:01PM edited Apr 9, 2024 3:26PM in Technology Stack - EBS (MOSC) 4 commentsAnswered

Oracle 12.2.12

19C DB,

Recently we upgraded to R 12.2.12(Application) and 19c (DB) and have a couple of issues with database objects. We are using Toad (9.7.2.5),

I can describe the package using F4 (This is not an issue)
I can not describe the table using F4 so the objects associated with the table trigger etc,
If I go to the schema browser and search for the trigger, I don't see any triggers but if I run the SQL, I can see the triggers,

select * from all_triggers where trigger_name like 'XX%'

Not sure what the issue is,

Tagged:

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month