Create Clone

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action provides support for ADD CLONE option functionality, letting you create a clone on an existing base table. This creates a table with a cloned definition but with no data.

Note: The base table must reside on a universal tablespace. For more information, see Tablespaces Wizard (DB2 Z/OS).

Platform Availability

To Create a Clone for One or More Tables:

  1. Initiate a Create Clone action against one or more tables. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the Create Clone wizard:
Step Settings and tasks

Action Options

Lets you provide a Clone Name.

Dependencies

Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies.

Preview

Displays the DDL that will execute the object action. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.

The clone for a table is not displayed in the Datasource Navigator/Explorer listing of tables for a data source. To determine whether a table has a clone, see the Dependencies tab/panel on a Table editor or on the wizard for object actions such as Drop or Rename.

After creating a clone for a table, you can exchange data between the base table and the clone.

Related Information