Re: SPEEDING UP IMPORT

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 8 Jul 2002 02:16:51 -0700
Message-ID: <a20d28ee.0207080116.5b1a676_at_posting.google.com>

vissuyk_at_yahoo.com (Vissu) wrote in message news:<2bedd6a7.0207071936.5bc2257c_at_posting.google.com>...
> Hi All,
>
> We have one table with 6mil rows (among others) and I am trying to
> import into the new instance. It is taking very long time (several
> hours) and I am ending up with some problems.
>
> I know this wont be done on a daily basis, but how can I speed it up ?
> I have turned off constraints. Is there anything I can do to speed it
> up?
>
> Thanks
>
> Vissu

Please visit

http://www.oracledba.co.uk/tips/import_speed.htm

Regards

Sybrand Bakker
Senior Oracle DBA Received on Mon Jul 08 2002 - 11:16:51 CEST

This message: [ Message body ]
Next message: Nigel Pendse: "Re: Oracle OLAP provider for excel"
Previous message: Rauf Sarwar: "Re: Should all the key columns be of same data type?"
In reply to Vissu: "SPEEDING UP IMPORT"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message