Re: IMPort Utility
From: Ronald <ronr_at_wxs.nl>
Date: Tue, 18 Aug 1998 21:55:44 +0200
Message-ID: <01HW.B1FFA8E0000F9322024383E0_at_news.wxs.nl>
Date: Tue, 18 Aug 1998 21:55:44 +0200
Message-ID: <01HW.B1FFA8E0000F9322024383E0_at_news.wxs.nl>
On Sun, 16 Aug 1998 5:57:21 +0200, Dan DiNardo wrote
(in message <6r5lb1$asv$1_at_news-2.news.gte.net>):
>
> Is there any way to optimize the process of importing a table/indexes using
> the IMPort utility? i.e. Can LOGGING be turned off for the database while
> importing the table? Should logging be turned off at the database,
> tablespace or table? What is the most effective?
Just drop the indexes and import the rows only. After that build the indexes. That should be much MUCH faster. You can also specify DIRECTPATH=Y at export time.
-- Ronald --------------------------------------------------------------------------- mailto:ronr_at_wxs.nl http://home.wxs.nl/~ronr/RonR.html (last update: june 8th, 1998) http://www.maccentral.com/news/9804/migration.shtml (forward migration home)Received on Tue Aug 18 1998 - 21:55:44 CEST