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/somo@somo.world 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!