Download Latest Version
DataMigrator-64bit-for-Oracle.zip (5.6 MB)
Get an email when there's a new version of Data Migrator for Oracle
| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| Parent folder | |||
| Oracle-to-PostgreSQL-DataMigrator-64bit.zip | 2014-12-12 | 4.3 MB | |
| README.txt | 2014-12-12 | 35.8 kB | |
| Oracle-to-PostgreSQL-DataMigrator-32bit.zip | 2014-12-12 | 4.4 MB | |
| Totals: 3 Items | 8.8 MB | 0 | |
## ##dm32.exe -h ALL ---------------------------------------------------------------------- #FreeUkraine #SaveUkraine #StopRussia #PutinKhuilo #CrimeaIsUkraine ---------------------------------------------------------------------- Oracle to PostgreSQL DataMigrator (v1.23.9, beta, 2014/12/12 09:57:58) [32bit] Copyright (c): 2014 Alex Buzunov, All rigts reserved. Agreement: Use this tool at your own risk. Author is not liable for any damages or losses related to the use of this software. ---------------------------------------------------------------------- From Oracle: Set following command line arguments to copy from Oracle to PostgreSQL: -w copy_vector -o pool_size -r num_of_shards -t field_term -l lame_duck -K keep_data_file -1 arg_1 -2 arg_2 -3 arg_3 -q query_sql_file -Q query_sql_dir -c from_table -P from_partition -S from_sub_partition -f from_db -e nls_date_format -m nls_timestamp_format -O nls_timestamp_tz_format -z source_client_home -u to_user -p to_passwd -d to_db_name -s to_db_server -a to_table -Z target_client_home -T target_port Here: (Common) -w [--copy_vector] Data copy direction. (Common) -o [--pool_size] Pool size. (Common) -r [--num_of_shards] Number of shards. (Common) -t [--field_term] Field terminator. (Common) -l [--lame_duck] Limit rows (lame duck run). (Common) -K [--keep_data_file] Keep data dump. (Common) -1 [--arg_1] Generic string argument 1. (Common) -2 [--arg_2] Generic string argument 2. (Common) -3 [--arg_3] Generic string argument 3. (From Oracle) -q [--query_sql_file] Input file with Oracle query sql. (From Oracle) -Q [--query_sql_dir] Input dir with Oracle query files sql. (From Oracle) -c [--from_table] From table. (From Oracle) -P [--from_partition] From partition. (From Oracle) -S [--from_sub_partition] From sub-partition. (From Oracle) -f [--from_db] From database. (From Oracle) -e [--nls_date_format] nls_date_format for source. (From Oracle) -m [--nls_timestamp_format] nls_timestamp_format for source. (From Oracle) -O [--nls_timestamp_tz_format] nls_timestamp_tz_format for source. (From Oracle) -z [--source_client_home] Path to Oracle client home. (To PostgreSQL) -u [--to_user] Target PostgreSQL db user. (To PostgreSQL) -p [--to_passwd] Target PostgreSQL db user password. (To PostgreSQL) -d [--to_db_name] Target PostgreSQL database. (To PostgreSQL) -s [--to_db_server] Target PostgreSQL db instance name. (To PostgreSQL) -a [--to_table] Target PostgreSQL table. (To PostgreSQL) -Z [--target_client_home] Path to PostgreSQL client home bin dir. (To PostgreSQL) -T [--target_port] Connection port for target PostgreSQL. --USE CASES-- 1. Oracle_to_PostgreSQL. 18 use cases. Oracle_to_PostgreSQL: 18 use case(s) available: 1. ORA_DateTable_to_PGRES - Copy Oracle table1 into PostgreSQL table. 2. ORA_Partition_KeepSpoolFile_to_PGRES - Copy Oracle partition into PostgreSQL table. 3. ORA_Partition_Limit10_to_PGRES - Copy only 10 rows from Oracle partition into PostgreSQL table. 4. ORA_Partition_to_PGRES - Copy Oracle partition into PostgreSQL table. 5. ORA_QueryDir_Limit10_to_PGRES - Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_ora". Copy only 10 rows from Oracle query results into PostgreSQL table. 6. ORA_QueryDir_to_PGRES - Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_ora". Copy Oracle query results into PostgreSQL table. 7. ORA_QueryFile_Limit10_to_PGRES - Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\oracle_query.sql". Copy only 10 rows from Oracle query results into PostgreSQL table. 8. ORA_QueryFile_to_PGRES - Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\oracle_query.sql". Copy Oracle query results into PostgreSQL table. 9. ORA_ShardedPartition_to_PGRES - Break input sharded partition into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy Oracle sharded partition into PostgreSQL table. 10. ORA_ShardedSubpartition_to_PGRES - Break input sharded sub-partition into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy Oracle sharded sub-partition into PostgreSQL table. 11. ORA_ShardedTable_to_PGRES - Break input table1 into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy Oracle table1 into PostgreSQL table. 12. ORA_Subpartition_KeepSpoolFile_to_PGRES - Copy Oracle sub-partition into PostgreSQL table. 13. ORA_Subpartition_Limit10_to_PGRES - Copy only 10 rows from Oracle sub-partition into PostgreSQL table. 14. ORA_Subpartition_to_PGRES - Copy Oracle sub-partition into PostgreSQL table. 15. ORA_Table_KeepSpoolFile_to_PGRES - Copy Oracle table1 into PostgreSQL table. 16. ORA_Table_Limit10_to_PGRES - Copy only 10 rows from Oracle table1 into PostgreSQL table. 17. ORA_TimestampTable_to_PGRES - Copy Oracle table1 into PostgreSQL table. 18. ORA_TimezoneTable_to_PGRES - Copy Oracle table1 into PostgreSQL table. --DETAILS-- -USE-CASE # 1 Use case name: ORA_DateTable->PGRES Description: Copy Oracle table1 into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -c SCOTT.Date_test_from ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Date_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 2 Use case name: ORA_Partition_KeepSpoolFile->PGRES Description: Copy Oracle partition into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -K[--keep_data_file] is "Keep data dump." -c[--from_table] is "From table." -P[--from_partition] is "From partition." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -K 1 ^ -c SCOTT.Partitioned_test_from ^ -P part_15 ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 3 Use case name: ORA_Partition_Limit10->PGRES Description: Copy only 10 rows from Oracle partition into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -l[--lame_duck] is "Limit rows (lame duck run)." -c[--from_table] is "From table." -P[--from_partition] is "From partition." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 10 ^ -c SCOTT.Partitioned_test_from ^ -P part_15 ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 4 Use case name: ORA_Partition->PGRES Description: Copy Oracle partition into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -P[--from_partition] is "From partition." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -c SCOTT.Partitioned_test_from ^ -P part_15 ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 5 Use case name: ORA_QueryDir_Limit10->PGRES Description: Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_ora". Copy only 10 rows from Oracle query results into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -l[--lame_duck] is "Limit rows (lame duck run)." -Q[--query_sql_dir] is "Input dir with Oracle query files sql." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 10 ^ -Q c:\Python27\data_migrator_1239\test\v101\query\query_dir_ora ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 6 Use case name: ORA_QueryDir->PGRES Description: Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_ora". Copy Oracle query results into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -Q[--query_sql_dir] is "Input dir with Oracle query files sql." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -Q c:\Python27\data_migrator_1239\test\v101\query\query_dir_ora ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 7 Use case name: ORA_QueryFile_Limit10->PGRES Description: Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\oracle_query.sql". Copy only 10 rows from Oracle query results into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -l[--lame_duck] is "Limit rows (lame duck run)." -q[--query_sql_file] is "Input file with Oracle query sql." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 10 ^ -q c:\Python27\data_migrator_1239\test\v101\query\oracle_query.sql ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 8 Use case name: ORA_QueryFile->PGRES Description: Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\oracle_query.sql". Copy Oracle query results into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -q[--query_sql_file] is "Input file with Oracle query sql." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -q c:\Python27\data_migrator_1239\test\v101\query\oracle_query.sql ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 9 Use case name: ORA_ShardedPartition->PGRES Description: Break input sharded partition into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy Oracle sharded partition into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -P[--from_partition] is "From partition." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 3 ^ -r 3 ^ -t "|" ^ -c SCOTT.Partitioned_test_from ^ -P part_15 ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 10 Use case name: ORA_ShardedSubpartition->PGRES Description: Break input sharded sub-partition into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy Oracle sharded sub-partition into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -S[--from_sub_partition] is "From sub-partition." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 3 ^ -r 3 ^ -t "|" ^ -c SCOTT.Sub_Partitioned_test_from ^ -S part_15_sp1 ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 11 Use case name: ORA_ShardedTable->PGRES Description: Break input table1 into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy Oracle table1 into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 3 ^ -r 3 ^ -t "|" ^ -c SCOTT.Timestamp_test_from ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 12 Use case name: ORA_Subpartition_KeepSpoolFile->PGRES Description: Copy Oracle sub-partition into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -K[--keep_data_file] is "Keep data dump." -c[--from_table] is "From table." -S[--from_sub_partition] is "From sub-partition." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -K 1 ^ -c SCOTT.Sub_Partitioned_test_from ^ -S part_15_sp1 ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 13 Use case name: ORA_Subpartition_Limit10->PGRES Description: Copy only 10 rows from Oracle sub-partition into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -l[--lame_duck] is "Limit rows (lame duck run)." -c[--from_table] is "From table." -S[--from_sub_partition] is "From sub-partition." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 10 ^ -c SCOTT.Sub_Partitioned_test_from ^ -S part_15_sp1 ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 14 Use case name: ORA_Subpartition->PGRES Description: Copy Oracle sub-partition into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -S[--from_sub_partition] is "From sub-partition." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -c SCOTT.Sub_Partitioned_test_from ^ -S part_15_sp1 ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 15 Use case name: ORA_Table_KeepSpoolFile->PGRES Description: Copy Oracle table1 into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -K[--keep_data_file] is "Keep data dump." -c[--from_table] is "From table." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -K 1 ^ -c SCOTT.Timestamp_test_from ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 16 Use case name: ORA_Table_Limit10->PGRES Description: Copy only 10 rows from Oracle table1 into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -l[--lame_duck] is "Limit rows (lame duck run)." -c[--from_table] is "From table." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 10 ^ -c SCOTT.Timestamp_test_from ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 17 Use case name: ORA_TimestampTable->PGRES Description: Copy Oracle table1 into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -c SCOTT.Timestamp_test_from ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timestamp_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434 -USE-CASE # 18 Use case name: ORA_TimezoneTable->PGRES Description: Copy Oracle table1 into PostgreSQL table. Arguments: -w[--copy_vector] is "Data copy direction." -o[--pool_size] is "Pool size." -r[--num_of_shards] is "Number of shards." -t[--field_term] is "Field terminator." -c[--from_table] is "From table." -f[--from_db] is "From database." -e[--nls_date_format] is "nls_date_format for source." -m[--nls_timestamp_format] is "nls_timestamp_format for source." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for source." -z[--source_client_home] is "Path to Oracle client home." -u[--to_user] is "Target PostgreSQL db user." -p[--to_passwd] is "Target PostgreSQL db user password." -d[--to_db_name] is "Target PostgreSQL database." -s[--to_db_server] is "Target PostgreSQL db instance name." -a[--to_table] is "Target PostgreSQL table." -Z[--target_client_home] is "Path to PostgreSQL client home bin dir." -T[--target_port] is "Connection port for target PostgreSQL." Example: echo y|c:\Python27\dm_dist_32\20141212_095758\dm32\dm32.exe ^ -w ora2pgres ^ -o 1 ^ -r 1 ^ -t "|" ^ -c SCOTT.Timezone_test_from ^ -f SCOTT/tiger2@orcl ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24:MI:SS" ^ -O "YYYY-MM-DD HH:MI:SS.FF3 TZH:TZM" ^ -z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" ^ -u "postgres" ^ -p "postgre_pwd" ^ -d "postgres" ^ -s "localhost" ^ -a "Timezone_test_to" ^ -Z "C:\Program Files\PostgreSQL\9.4\bin" ^ -T 5434