Member Avatar for pointers

Hi,

I have a question pls clarify it.
If a table is created and grant, index, triggers, synonyms etc are defined on the table. what happens to grant, index, triggers, synonyms etc if the table is dropped.
What is the data dictionary needs to be checked to validate all these dependent objects with respect to the table.

Regards,
Pointers.

  • 3 Contributors
  • 2 Replies
  • 87 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for alit2002

Hi

If you drop a table the index will also be dropped. The trigger and synonym will still exist and if you want to get rid of them you will need to drop these objects as well.

Alistair

Member Avatar for debasisdas

In 10g once the table is dropped its related objects are renamed and stored in recyclebin. But grants will not work anymore.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.