Prasad,
there's no way to make the import begin again from the same point. You can
only rerun the same import and that will probably leave you with duplicate
rows.

I see that Regis mentioned 9i's resumable space management but unfortunately
this doen't help in your situation because the nature of this feature is
that it suspends the problem session until the problem is cleared. It can't
be used to restart a failed session (because it was created to avoid
transactions failing in the first place).

Regards,
Mike Hately

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] 14 December 2003 11:16
To: LazyDBA.com Discussion
Subject: Resume IMPORT



Hi,

I am importing a huge dmp file of size 3GB. The command I am using is
imp <DB Connection> commit=y buffer=52428800 file=<File_Path> ignore=y
log=<Log_File> fromuser=<FROMUSER> touser=<TOUSER>

I required to stop it in the middle during import.

How do I resume the import later?

Please suggest me with the command.

Thanks in Advance,

Prasad.

Oracle LazyDBA home page