dblink_ora_copy() v16
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:
Where:
conn_name
specifies the name of the link.command
specifies the text of the SQLSELECT
statement 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 whether the server performs aTRUNCATE
on the table prior to copying. SpecifyTRUE
if you want the server toTRUNCATE
the table.truncate
is optional. If omitted, the value isFALSE
.count
reports status information everyn
records, wheren
is a number. While the function executes, EDB Postgres Advanced Server raises a notice of severityINFO
with each iteration of the count. For example, if FeedbackCount is10
,dblink_ora_copy()
raises a notice every 10 records.count
is optional. If omitted, the value is0
.