Update set and delete table

[ideamax]

Hi,

I want to delete a table and capture the changes in an update set so that i can move these changes to other instance.
I tried do the same but the delete entries for the table are not getting captured in the update set.

Is this the expected behaviour?

Thanks.

[john_andersen]

Sorry to lead you astray. You are correct, the deletion of a table does not appear to get capture in update sets.

I hardly, if ever, delete tables, so I haven't encountered this use case before.

As mentioned before, I hardly recommend the deletion of a table, unless it was one that was newly created without much interaction.

You can take steps that ARE captured in an update set to make the table somewhat invisible the other users by:
1) Remove it from any applications in the navigation pane
2) Make the table inactive in the sys_dictionary - this will prevent it from showing up in most drop down lists, etc
3) If you want to get really serious about it, you could create ACLs around the table that keep people from accessing it in the future (this is a little overkill)

[ideamax]

thanks for the information john.. so if i want to delete any table doing it manually is the only option?

[john_andersen]

I am sure you can get creative to do it more programmatically, but from where I stand, manually is probably the best option. But in all honesty, NOT deleting it is usually the best option.

Just my two cents.