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.
Jump to PostHi
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
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
In 10g once the table is dropped its related objects are renamed and stored in recyclebin. But grants will not work anymore.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.