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?

It would probably be a lot faster to use DB links. Just remember that exp/imp gets all of the grants, and triggers too. A copy over a dblink does not.

create table mytable

    tablespace mytablespace
    nologging
    as select * from mytable_at_DB1
/