Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: More efficient way to exp / imp
Chang - a few tips :-
Export with Direct option
If possible don;t use consistent=Y
When importing
Precreate the tables
Donnot import Indexes create them later with the online option.
Hope this helps
"C Chang" <cschang_at_maxinter.net> wrote in message
news:3E3331DE.754_at_maxinter.net...
> I have a 3 G database on a NT 4 (P-550) box installed with 8.1.6
> oracle. There are 5 X 16 G HD and 1 G RAM. I tried to export and
> import the DB and found that my current methods are not faster enough.
> What i did were either to use Full=Y or fromuser=.. in export and import
> back accordingly. But both way are too slow and took at least 48 hours
> to finish. I examined my system and found that the only full tablespace
> is one of the tablespaces for data, rest of tablespace is quite empty.
> Therefore I can not use the imp commit=N, which could not extend the
> tablespace during the import. I also read the articles from other
> reference (One-on-One ) and websites for clues. I am wondering that
> dividing the DB to several export files will speed up? or export/import
> the DB table by table, then indexed. I have never done those. Can
> anyone have done either one sharing their experience? Thanks.
>
> C Chang
>
Received on Sun Jan 26 2003 - 01:28:39 CST