7.4 Schema Object Selection Options

Table of Contents Previous Next


7 Migration Toolkit Command Options : 7.4 Schema Object Selection Options

-tables table_list
Import the selected tables from the source schema. table_list is a comma-separated list (with no intervening space characters) of table names (e.g., -tables emp,dept,acctg).
By default, Migration Toolkit does not implement migration of check constraints and default clauses from a Sybase database. Include the ‑ignoreCheckConstFilter parameter when specifying the -constraints parameter to migrate constraints and default clauses from a Sybase database.
This option is valid only when importing an entire schema or when the -allTables or -tables table_list options are specified.
Import the table indexes. This option is valid when importing an entire schema or when the -allTables or -tables table_list option is specified.
Import the views from the source schema. Please note that this option will migrate both dynamic and materialized views from the source. (Oracle and Postgres materialized views are supported.)
-views view_list
Import the specified materialized or dynamic views from the source schema. (Oracle and Postgres materialized views are supported.) view_list is a comma-separated list (with no intervening space characters) of view names (e.g., -views all_emp,mgmt_list,acct_list).
-sequences sequence_list
Import the selected sequences from the source schema. sequence_list is a comma-separated list (with no intervening space characters) of sequence names.
-procs procedures_list
Import the selected stored procedures from the source schema. procedures_list is a comma-separated list (with no intervening space characters) of procedure names.
-funcs function_list
Import the selected functions from the source schema. function_list is a comma-separated list (with no intervening space characters) of function names.
When false, disables validation of the function body during function creation (to avoid errors if the function contains forward references). The default value is true.
-packages package_list
Import the selected packages from the source schema. package_list is a comma-separated list (with no intervening space characters) of package names.
-allDomains
Import all queues from the source schema. These are queues created and managed by the DBMS_AQ and DBMS_AQADM built-in packages. When Oracle is the source database, the -objectTypes option must also be specified. When Advanced Server is the source database, the -allDomains and -allTables options must also be specified. (Oracle and Advanced Server queues are supported.)
-queues queue_list
Import the selected queues from the source schema. queue_list is a comma-separated list (with no intervening space characters) of queue names. These are queues created and managed by the DBMS_AQ and DBMS_AQADM built-in packages. When Oracle is the source database, the -objectTypes option must also be specified. When Advanced Server is the source database, the -allDomains and -allTables options must also be specified. (Oracle and Advanced Server queues are supported.)
-allRules

7 Migration Toolkit Command Options : 7.4 Schema Object Selection Options

Table of Contents Previous Next