5. Утилита Iloader#
Утилита Iloader является дополнительным инструментом работы с БД.
Она выполняет следующие функции:
— загрузка данных в БД,
— перенос данных между БД,
— восстановление данных БД.
Выполните пункты 3.2.1-3.2.3 руководства "Быстрый старт" для работы с Iloader.
5.1 Справка по Iloader#
Введите следующую команду для получения справки по утилите Iloader:
altibase@ed259465ef2e:~$ iloader -h
=====================================================================
ILOADER HELP Screen
=====================================================================
Usage : iloader [-h]
[-s server_name] [-u user_name] [-p password]
[-port port_no] [-silent] [-nst] [-displayquery]
[-NLS_USE nls_name]
[-prefer_ipv6]
[-geom WKB]
[-ssl_ca CA_file_path | -ssl_capath CA_dir_path]
[-ssl_cert certificate_file_path]
[-ssl_key key_file_path]
[-ssl_verify]
[-ssl_cipher cipher_list]
[{ in | out | formout | structout | help }
[-d datafile or datafiles] [-f formatfile]
[-T table_name] [-F firstrow] [-L lastrow]
[-t field_term] [-r row_term] [-mode mode_type]
[-commit commit_unit] [-bad badfile]
[-log logfile] [-e enclosing] [-array count]
[-replication true/false] [-split number]
[-readsize size] [-errors count]
[-lob lob_option_string] [-atomic]
[-parallel count] [-direct]
[-rule csv]
[-partition]
[-dry-run]
[-prefetch_rows]
[-async_prefetch off|on|auto]
[-geom WKB]
[-stmt_prefix]]
-h : This screen
-s : Specify server name to connect
-u : Specify user name to connect
-p : Specify password of specify user name
-port : Specify port number to communication
-silent : No display Copyright
-nst : No display Elapsed Time
-displayquery : display query string
-NLS_USE : Specify NLS
-prefer_ipv6 : Prefer resolving server_name to IPv6 Address
-geom : Specify geometry format such as WKB
-ssl_ca : The path to a CA certificate file
-ssl_cpath : The path to a directory that contains CA certificates
-ssl_cert : The path to the client certificate
-ssl_key : The path to the client private key file
-ssl_verify : Whether the client is to check certificates
that are sent by the server to the client
-ssl_cipher : A list of SSL ciphers
=====================================================================