If you are in Oracle9i...the answer is Yes.
The RESUMABLE new features is available and works with EXP/IMP and others...
You need to have the RESUMABLE privilege in order to use this feature.
The best situation that suits you is cause ORA-1536 (Space quota exceeded
for tablespace...)
1. Connect as a DBA and find the default tablespace of the user of FROMUSER
option of your import
2. Make sure that user does not have RESOURCE role(Or revoke UNLIMITED
TABLESPACE priv to RESOURCE)
3. Reduce his QUOTA...while your import is still going.(So if the user had
Quota unlimited on the default tablespace set it to 50MB and I am sure that
3GB export will fail).

Again this a theory that could help you accomplish this...please very with
metalink how to enable the RESUMABLE feature without having to shutdown the
database....

Regis

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Sunday, December 14, 2003 11:16 AM
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.
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************

Oracle LazyDBA home page