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 | |||
| PostgreSQL-to-Oracle-DataMigrator1-64bit.zip | 2014-12-16 | 4.3 MB | |
| README.txt | 2014-12-16 | 31.0 kB | |
| PostgreSQL-to-Oracle-DataMigrator1-32bit.zip | 2014-12-16 | 4.4 MB | |
| Totals: 3 Items | 8.7 MB | 0 | |
## ##dm32.exe -h ALL ---------------------------------------------------------------------- PostgreSQL to Oracle DataMigrator (v1.23.9, beta, 2014/12/15 21:33:56) [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 PostgreSQL: Set following command line arguments to copy from PostgreSQL to Oracle: -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_any_partition -j from_user -x from_passwd -b from_db_name -n from_db_server -z source_client_home -R source_port -g to_db -a to_table -e nls_date_format -m nls_timestamp_format -O nls_timestamp_tz_format -Z target_client_home 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 PostgreSQL) -q [--query_sql_file] Input file with PostgreSQL query sql. (From PostgreSQL) -Q [--query_sql_dir] Input dir with PostgreSQL query files sql. (From PostgreSQL) -c [--from_table] From table. (From PostgreSQL) -P [--from_any_partition] From partition. (From PostgreSQL) -j [--from_user] PostgreSQL source user. (From PostgreSQL) -x [--from_passwd] PostgreSQL source user password. (From PostgreSQL) -b [--from_db_name] PostgreSQL source database. (From PostgreSQL) -n [--from_db_server] PostgreSQL source instance name. (From PostgreSQL) -z [--source_client_home] Path to PostgreSQL client home. (From PostgreSQL) -R [--source_port] Connection port for source PostgreSQL. (To Oracle) -g [--to_db] To Oracle database. (To Oracle) -a [--to_table] To Oracle table. (To Oracle) -e [--nls_date_format] nls_date_format for target. (To Oracle) -m [--nls_timestamp_format] nls_timestamp_format for target. (To Oracle) -O [--nls_timestamp_tz_format] nls_timestamp_tz_format for target. (To Oracle) -Z [--target_client_home] Path to Oracle client home bin dir. --USE CASES-- 1. PostgreSQL_to_Oracle. 15 use cases. PostgreSQL_to_Oracle: 15 use case(s) available: 1. PGRES_DateTable_to_ORA_Table - Copy PostgreSQL table into Oracle Table table. 2. PGRES_ParallelQueryDir_to_ORA_Table - Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_pgres". Copy PostgreSQL query results into Oracle Table table. 3. PGRES_Partition_Limit33_to_ORA_Table - Copy only 33 rows from PostgreSQL partition into Oracle Table table. 4. PGRES_Partition_to_ORA_Table - Copy PostgreSQL partition into Oracle Table table. 5. PGRES_QueryDir_Limit12_to_ORA_Table - Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_pgres". Copy only 12 rows from PostgreSQL query results into Oracle Table table. 6. PGRES_QueryDir_to_ORA_Table - Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_pgres". Copy PostgreSQL query results into Oracle Table table. 7. PGRES_QueryFile_Limit11_to_ORA_Table - Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\postgre_query.sql". Copy only 11 rows from PostgreSQL query results into Oracle Table table. 8. PGRES_QueryFile_to_ORA_Table - Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\postgre_query.sql". Copy PostgreSQL query results into Oracle Table table. 9. PGRES_ShardedPartition_to_ORA_Table - 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 PostgreSQL sharded partition into Oracle Table table. 10. PGRES_ShardedQueryFile_to_ORA_Table - Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\postgre_query.sql". Break input query results into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy PostgreSQL query results into Oracle Table table. 11. PGRES_ShardedTable_to_ORA_Table - Break input table into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy PostgreSQL table into Oracle Table table. 12. PGRES_Table_KeepSpoolFile_to_ORA_Table - Copy PostgreSQL table into Oracle Table table. 13. PGRES_Table_Limit15_to_ORA_Table - Copy only 15 rows from PostgreSQL table into Oracle Table table. 14. PGRES_TimestampTable_to_ORA_Table - Copy PostgreSQL table into Oracle Table table. 15. PGRES_TimezoneTable_to_ORA_Table - Copy PostgreSQL table into Oracle Table table. --DETAILS-- -USE-CASE # 1 Use case name: PGRES_DateTable_to_ORA_Table Description: Copy PostgreSQL table into Oracle Table 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." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -c Date_test_from ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Date_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 2 Use case name: PGRES_ParallelQueryDir_to_ORA_Table Description: Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_pgres". Copy PostgreSQL query results into Oracle Table 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 PostgreSQL query files sql." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 3 ^ -r 3 ^ -t "|" ^ -Q c:\Python27\data_migrator_1239\test\v101\query\query_dir_pgres ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 3 Use case name: PGRES_Partition_Limit33_to_ORA_Table Description: Copy only 33 rows from PostgreSQL partition into Oracle Table 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_any_partition] is "From partition." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 33 ^ -c Partitioned_test_from ^ -P Partitioned_test_from_2014 ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 4 Use case name: PGRES_Partition_to_ORA_Table Description: Copy PostgreSQL partition into Oracle Table 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_any_partition] is "From partition." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -c Partitioned_test_from ^ -P Partitioned_test_from_2014 ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 5 Use case name: PGRES_QueryDir_Limit12_to_ORA_Table Description: Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_pgres". Copy only 12 rows from PostgreSQL query results into Oracle Table 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 PostgreSQL query files sql." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 12 ^ -Q c:\Python27\data_migrator_1239\test\v101\query\query_dir_pgres ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 6 Use case name: PGRES_QueryDir_to_ORA_Table Description: Read each SQL query file from a directory "c:\Python27\data_migrator_1239\test\v101\query\query_dir_pgres". Copy PostgreSQL query results into Oracle Table 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 PostgreSQL query files sql." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -Q c:\Python27\data_migrator_1239\test\v101\query\query_dir_pgres ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 7 Use case name: PGRES_QueryFile_Limit11_to_ORA_Table Description: Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\postgre_query.sql". Copy only 11 rows from PostgreSQL query results into Oracle Table 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 PostgreSQL query sql." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 11 ^ -q c:\Python27\data_migrator_1239\test\v101\query\postgre_query.sql ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 8 Use case name: PGRES_QueryFile_to_ORA_Table Description: Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\postgre_query.sql". Copy PostgreSQL query results into Oracle Table 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 PostgreSQL query sql." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -q c:\Python27\data_migrator_1239\test\v101\query\postgre_query.sql ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 9 Use case name: PGRES_ShardedPartition_to_ORA_Table 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 PostgreSQL sharded partition into Oracle Table 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_any_partition] is "From partition." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 3 ^ -r 3 ^ -t "|" ^ -c Partitioned_test_from ^ -P Partitioned_test_from_2014 ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 10 Use case name: PGRES_ShardedQueryFile_to_ORA_Table Description: Read SQL from a query file "c:\Python27\data_migrator_1239\test\v101\query\postgre_query.sql". Break input query results into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy PostgreSQL query results into Oracle Table 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 PostgreSQL query sql." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 3 ^ -r 3 ^ -t "|" ^ -q c:\Python27\data_migrator_1239\test\v101\query\postgre_query.sql ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 11 Use case name: PGRES_ShardedTable_to_ORA_Table Description: Break input table into 3 logical shards (-r[--num_of_shards] 3) and run copy process on each shard in thread pool (-o[--pool_size] 3). Copy PostgreSQL table into Oracle Table 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." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 3 ^ -r 3 ^ -t "|" ^ -c Timestamp_test_from ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 12 Use case name: PGRES_Table_KeepSpoolFile_to_ORA_Table Description: Copy PostgreSQL table into Oracle Table 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." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -K 1 ^ -c Timestamp_test_from ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 13 Use case name: PGRES_Table_Limit15_to_ORA_Table Description: Copy only 15 rows from PostgreSQL table into Oracle Table 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." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -l 15 ^ -c Timestamp_test_from ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 14 Use case name: PGRES_TimestampTable_to_ORA_Table Description: Copy PostgreSQL table into Oracle Table 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." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -c Timestamp_test_from ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timestamp_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN" -USE-CASE # 15 Use case name: PGRES_TimezoneTable_to_ORA_Table Description: Copy PostgreSQL table into Oracle Table 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." -j[--from_user] is "PostgreSQL source user." -x[--from_passwd] is "PostgreSQL source user password." -b[--from_db_name] is "PostgreSQL source database." -n[--from_db_server] is "PostgreSQL source instance name." -z[--source_client_home] is "Path to PostgreSQL client home." -R[--source_port] is "Connection port for source PostgreSQL." -g[--to_db] is "To Oracle database." -a[--to_table] is "To Oracle table." -e[--nls_date_format] is "nls_date_format for target." -m[--nls_timestamp_format] is "nls_timestamp_format for target." -O[--nls_timestamp_tz_format] is "nls_timestamp_tz_format for target." -Z[--target_client_home] is "Path to Oracle client home bin dir." Example: echo y|c:\Python27\dm_dist_32\20141215_213356\dm32\dm32.exe ^ -w pgres2ora ^ -o 1 ^ -r 1 ^ -t "|" ^ -c Timezone_test_from ^ -j "postgres" ^ -x "postgre_pwd" ^ -b "postgres" ^ -n "localhost" ^ -z "C:\Program Files\PostgreSQL\9.4\bin" ^ -R 5434 ^ -g SCOTT/tiger2@orcl ^ -a SCOTT.Timezone_test_to ^ -e "YYYY-MM-DD HH24:MI:SS" ^ -m "YYYY-MM-DD HH24.MI.SS.FF3" ^ -O "YYYY-MM-DD HH24:MI:SS.FF3 TZH:TZM" ^ -Z "C:\app\alex_buz\product\11.2.0\dbhome_2\BIN"