User Guide

11.0
- 10.0

Back Next

Generating Target Tables Based on Source Table Schema

You can optionally generate target tables based on source table schema.

In the Fast Clone Console, connect to the source database and the target database.

Click

Schema

Schema creation script

on the menu bar, or click the

Generate tables on destination script

button on the toolbar.

The

Generating Schema for the Target

dialog box appears.

In the

Schema/owner

field, enter the schema or owner name of source tables that you want to use to generate the target tables.

The tables that match the selected schema or owner name are listed in the

Tables

box.

The following image shows an example listing:

To filter the list of tables, in the Filter
field, enter the first few letters of the source table names that you want to use for generating target tables. For case-sensitive filtering, enclose the filter value in double quotation marks.

Only the tables that match the filter criteria are listed in the

Tables

box.

Select the tables to use for generating the target tables:

To select all listed tables, click

Select All

To select tables individually, select the

Convert

check box next to each table.

Under

Target

, in the

Schema

field, enter a schema name for the target.

In the

Database type

list, select the target database type.

To create the tables, perform one of the following actions:

To generate SQL CREATE TABLE scripts, click

Convert

. Then in the

Save

dialog box, save the generated scripts to a directory. You can run the scripts on the target system to create the target tables.

The Fast Clone Console generates the SQL CREATE TABLE script in the specified directory. If you use sequence objects on the Oracle source, the Fast Clone Console also creates an SQL script for generating sequence objects in the specified directory. To name this script, the Fast Clone Console uses a name of the SQL CREATE TABLE script with the prefix _sequences.

Click

Run

to create the tables on the target immediately.

Generating Target Tables

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal