Toad for Oracle 15.0 - Getting Started Guide

Copy Objects to Another Schema

You can copy objects to another schema.

To copy objects to another schema

1. Click on the Standard toolbar to open the Schema Browser.
2. Right-click the object you want to copy in the left-hand side and select Create in another schema.
3. Select export settings and click OK. See Export DDL in the online help for more information.
4. Enter the destination connection and destination schemas.
5. To review the script to create the objects, click the Script tab.
6. Click Execute.

Create or Alter Objects

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.

Notes:

• Toad strictly adheres to the database security. Consult your DBA to learn what privileges you have.
• You can use an existing object as a template when creating a new one. Use Existing Object as Template for New Objects

To create an object

1. Click on the Standard toolbar to open the Schema Browser.

2. Select Database | Create | <Object type>.

3. Complete the fields as necessary.

4. To add the object to the Project Manager, select Add to Project Manager.
5. To view the CREATE statement, click Show SQL or select the SQL tab.

6. Click OK or Execute to create the object immediately.

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.

Use Existing Object as Template for New Objects

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

1. Click on the Standard toolbar to open the Schema Browser.
2. Right-click the object you want to use as a template in the left-hand side and select Create Like.
3. Complete the fields as necessary.
4. To view the CREATE statement, click Show SQL or select the SQL tab.
5. Click OK or Execute to create the object immediately.

Drop (Delete) Objects