RE: How to speed up import

From: Kevin Lange <kgel_at_ppoone.com>
Date: Tue, 03 Sep 2002 14:00:06 -0800
Message-ID: <F001.004C6A36.20020903140006@fatcity.com>

Are you importing to existing tables with indexes ?? Are you importing the indexes ??

One big way to speed up an import is to NOT import any indexes and, if the objects exist on the target database, to delete any indexes and rebuild them in a sperate action after the import is complete.

-----Original Message-----
Sent: Tuesday, September 03, 2002 4:35 PM To: Multiple recipients of list ORACLE-L

I do backup database nightly using export utility. When I restore database using import, it takes more than 6 hours to finish. Is there a way to speed up import process? Please advise.

Thanks,
David
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nguyen, David M
INET: david.m.nguyen_at_xo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------