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

SQL*Loader is a fast and easy way to get data into a database without writing long, complicated scripts. Find out how to to work better with Oracle objects.