Re: More efficient way to exp / imp

C Chang wrote:

> 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

What are you going to do with the export? That might help us make a suggestion.

Daniel Morgan Received on Sat Jan 25 2003 - 19:18:46 CST