Re: exp/imp vs DB link

"Cameron Abbott" <cvabbott_at_altavista.com> wrote in message news:9s6ari$80j$1_at_bcarh8ab.ca.nortel.com...
> As a follow up to my import question on Friday, would it be any quicker to
> create all the tables in the new DB without any data, then create a DB
link
> and then select the data from DB1.table into DB2.table?
>
> FYI the import finally finished after 38 hours. I am going to try the
> suggestion of doing th import using indexfile to see if it any faster.
>
> Thanks for your help.
>
> Cameron
>
>

You could try that scenario using the SQL*Plus COPY command (Note: COPY is *not* a *pl/sql* command).
Using ordinary insert select constructs in pl/sql would be slower unless you can use bulk load.
The final resort in this matter is of course using Pro*C and/or OCI.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address