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 Sat Jan 25 2003 - 18:54:54 CST
