blob: 406c48b5dc6b22baebbf193c6b49ea6f5a48a26a [file] [log] [blame]
:mod:`airflow.contrib.operators.oracle_to_oracle_transfer`
==========================================================
.. py:module:: airflow.contrib.operators.oracle_to_oracle_transfer
Module Contents
---------------
.. py:class:: OracleToOracleTransfer(oracle_destination_conn_id, destination_table, oracle_source_conn_id, source_sql, source_sql_params=None, rows_chunk=5000, *args, **kwargs)
Bases: :class:`airflow.models.BaseOperator`
Moves data from Oracle to Oracle.
:param oracle_destination_conn_id: destination Oracle connection.
:type oracle_destination_conn_id: str
:param destination_table: destination table to insert rows.
:type destination_table: str
:param oracle_source_conn_id: source Oracle connection.
:type oracle_source_conn_id: str
:param source_sql: SQL query to execute against the source Oracle
database. (templated)
:type source_sql: str
:param source_sql_params: Parameters to use in sql query. (templated)
:type source_sql_params: dict
:param rows_chunk: number of rows per chunk to commit.
:type rows_chunk: int
.. attribute:: template_fields
:annotation: = ['source_sql', 'source_sql_params']
.. attribute:: ui_color
:annotation: = #e08c8c
.. method:: _execute(self, src_hook, dest_hook, context)
.. method:: execute(self, context)