You can copy objects to another schema.
To copy objects to another schema
Toad lets you select Oracle object parameters and generate a DDL statement to create or alter objects. It is generally a good idea to review the DDL statement before executing it. When you execute the statement, Toad passes it to the database, and the object is created or altered.
The options to create or alter an object in Toad follow the parameters defined by Oracle. If you need clarification on what an option means or how it should be used, see Oracle's documentation for more information. Oracle provides detailed documentation about objects, including their purpose, properties, and restrictions.
To create an object
Right-click on the object type in the left-hand side and select .
Note: You can also create an object by selecting Database | Create | <Object type>.
Complete the fields as necessary.
Click OK or Execute to create the object immediately. You can also schedule the script to run later.
To alter an object
To alter or edit an object, double-click on it in the Schema Browser. To rename an object (if permitted) press F2.
Note: You cannot make any changes on the Alter Index | Column tab because Oracle does not permit an index to be altered that way. To alter an index, send the script to the editor (with a DROP command), edit the script, and then run it. As an alternative, you can right-click the index then choose Create Like. Enter a name for the new index, make the changes, and then drop the original index.
You can use an existing object as a template for creating a new object. Toad loads the original object's properties in the Create window for you to edit as necessary and execute.
Note: This feature is not available for all object types.
To create an object based on an existing one