Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

The temporary namespace while dropping removes any objects that are session-dependent, including schema-qualified objects, such as tables, functions, operators, or even extensions. In RDS for ...