Examples of copying sequences

These examples show the DDL that is generated when you copy sequences between heterogeneous databases.

The generated DDL is shown on the Preview DDL page in the Paste Database Objects wizard.

Table 1 shows an example of the DDL that is generated for copying a sequence from an Oracle Database 11g source database to a DB2® Version 9.7 for Linux®, UNIX®, and Windows® target database.

Table 1. Example of copying a sequence from Oracle Database 11g to DB2 Version 9.7 for Linux, UNIX, and Windows database
Oracle Database 11g sequence definition Generated DDL for DB2 Version 9.7 database
CREATE SEQUENCE customer_number
   START WITH 10000
   INCREMENT BY 10
   NOCYCLE;
CREATE SEQUENCE CUSTOMER_NUMBER
   START WITH 10000
   INCREMENT BY 10
   NOCYCLE;

Table 2 shows an example of the DDL that is generated for copying a sequence from a DB2 Version 9.7 for Linux, UNIX, and Windows source database to an Oracle Database 11g target database.

Table 2. Example of copying a sequence from DB2 Version 9.7 for Linux, UNIX, and Windows database to Oracle Database 11g
DB2 Version 9.7 database sequence definition Generated DDL for Oracle Database 11g
CREATE SEQUENCE customer_number
   START WITH 10000
   INCREMENT BY 10
   NOCYCLE;
CREATE SEQUENCE CUSTOMER_NUMBER
   START WITH 10000
   INCREMENT BY 10
   NOCYCLE;

Feedback