From: Anurag Verma <>
Date: Mon, 16 Jun 2008 11:39:18 -0700
Message-ID: <>


Can we use parallel degree option to copy a table from one database to another?

I have 2 Oracle 9i databases and have to copy some huge amount of data.

Thinking of various options and want to know whether I can implement parallel option (in the same way what we do with Parallel DMLs).

This is what the COPY syntax I am seeing from sqlplus utility.

usage: COPY FROM <db> TO <db> <opt> <table> { (<cols>) } USING <sel>
<db> : database string, e.g., hr/your_password_at_d:chicago-mktg
<opt> : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE
<table>: name of the destination table
<cols> : a comma-separated list of destination column aliases
<sel> : any valid SQL SELECT statement


Anurag Verma,
Database Administrator
ERCOT(Electric Reliability Council of Texas),
Texas 76574

Received on Mon Jun 16 2008 - 13:39:18 CDT

Original text of this message