Hi All,

I am importing a schema into my DB. No data included. However my import is taking very long. Each table has an average of 50 columns. I have around 2000 tables. The dump file is a mere 50 MB. Yet the import is taking 6 hours to run. I used this command

imp retail/[email protected] file=/usr2/flexcube/somo/data/29MarSchemaRetail.dmp full=Y buffer=8192 commit=Y ignore=Y log=/usr2/flexcube/somo/data/23Apr2001.log

Is there any way I can speed up the import. At this rate it will take two days to import the data!