The following examples show DDL that is generated when
you copy database objects.
Example of copying tables
These examples show the DDL that is generated when you
copy tables between heterogeneous databases.
Examples of copying constraints
These examples show the DDL that is generated when you
copy constraints between heterogeneous databases.
Examples of copying indexes
These examples show the DDL that is generated when you
copy indexes between heterogeneous databases.
Examples of copying triggers
These examples show the DDL that is generated when you
copy triggers between heterogeneous databases. The triggers are copied
as part of the tables to which they belong.
Examples of copying views
These examples show the DDL that is generated when you
copy views between heterogeneous databases.
Examples of copying PL/SQL procedures
These examples show the DDL that is generated when you
copy PL/SQL procedures between heterogeneous databases.
Examples of copying PL/SQL functions
These examples show the DDL that is generated when you
copy PL/SQL functions between heterogeneous databases.
Examples of copying PL/SQL packages
These examples show the DDL that is generated when you
copy PL/SQL packages between heterogeneous databases.
Examples of copying sequences
These examples show the DDL that is generated when you
copy sequences between heterogeneous databases.
Examples of copying synonyms
These examples show the DDL that is generated when you
copy synonyms between heterogeneous databases.
Examples of copying user-defined types
These examples show the DDL that is generated when you
copy user-defined types (UDTs) between heterogeneous databases.