A while back, someone aske about TRUNCATE vs DELETE. In reply, HillBillyToad offered the opinion that DROP and CREATE might be better options for quickly destroying all the data in a table. My understanding is that this also allows "recovery" of the table, if you're properly set up, using FLASHBACK. I can see significant advantages to that.
However, a lingering question remains... What's the impact of DROP and CREATE on dependency information in ORACLE? If I have dependent objects (procedures, views, etc), would the linkage to dependency information be lost? Or would ORACLE dynamically figure out all dependency relationships again on the CREATE?
Follow-up question: if you flashback a table to a prior version, is any dependency information restored?