First, can you separate out the time to truncate the tables and the time to
import the data? I am assuming that the vast majority of time is spent
importing data, but if truncating tables is taking a while, that would point
to other types of problems...

Is the hardware identical on the two machines? By system configuration, I
assume you mean that the RAID types are identical, that the dump files are
one the same speed disk or disks, and that all the data files, redo files,
UNDO tablespace, etc are laid out identically on the two servers.

Justin Cave <[Email address protected]
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: laxman
[mailto:oracledba-ezmlmshield-x39336428.[Email address protected]
Sent: Friday, October 08, 2004 1:01 AM
To: LazyDBA Discussion
Subject: Export from 8i and Import to 9i

Hi! Experts,

We are having 8i and 9i servers.
Frequently we will take some data export from 8i (8.1.7.4) and import in
9i (9.2.0.5) server.

We observed that export from 8i and import in the same server 8i is taking
20 minutes. (This includes truncation of tables also)
Where as export from 8i and import in the 9i server is taking 45 minutes.
(This includes truncation of tables also)

System configuration and database configuration and the structure is same.

Can any body give any idea....... how can I reduce the import and
truncation time in 9i server

Thanks in advance
ar laxman



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html







Oracle LazyDBA home page