dblink_ora_copy() v10

The dblink_ora_copy() function copies an Oracle table to an EDB table. The dblink_ora_copy() function returns a BIGINT value that represents the number of rows copied. The signature is:

dblink_ora_copy(<conn_name>, <command>, <schema_name>, <table_name>,
<truncate>, <count>)

Where:

  • conn_name specifies the name of the link.

  • command specifies the text of the SQL SELECT statement that will be invoked on the Oracle server.

  • schema_name specifies the name of the target schema.

  • table_name specifies the name of the target table.

  • truncate specifies if the server should TRUNCATE the table prior to copying; specify TRUE to indicate that the server should TRUNCATE the table. truncate is optional; if omitted, the value is FALSE.

  • count instructs the server to report status information every n record, where n is the number specified. During the execution of the function, Advanced Server raises a notice of severity INFO with each iteration of the count. For example, if FeedbackCount is 10, dblink_ora_copy() raises a notice every 10 records. count is optional; if omitted, the value is 0.