[Feature] Option to purge table for table materializations

[espenhoh]

Describe the Feature

Currently, running table amterializations causes the recycle bin to fill up on every dbt run. If the table was dropped with purge, it will skip the recycle bin and keep the table space clean. It should be an option to turn purge on/off.

Describe alternatives you've considered

No response

Who will this benefit?

Anyone using table materializations with dbt-oracle, who also have the recycle bin activated.

Anything else?

No response