Urgent: Import - approximate time taken

[appash]

Hi...

How long will it take to import full database of 65 tables?
Could somebody give me an approximate time...

Oracle 8.1.7 on HP-UX 11.0 platform


Thanks

[sonofsita]

it does not depend on the number of the tables but on the number of rows each table has

[julian]

Based on the info you give us, I would say from 10 minutes to 2 hours but I assume that they are not really megatabes. And if they have very few rows import might take even less than a minute :-)

[roobaron]

It will also depend on the number of indexes, constraints and triggers.
not to mention the OS i.e CPU power, no of CPU, memory, disk subsystem and other programs running at the same time.

Unfortunately Appash, you need to benchmark this and work the timing out for future imports. Use time or timex (UNIX command) to time how long the process runs for. on NT?

On single CPU unix machines i have seen times like
Total time: 3hrs
User time: 30 mins

This result is just what i have to work with on the databases i support.... your results will be different.

[appash]

Thanks a lot folks...