Unfortunately the answer is: NO
But there are ways to improve your import.
For instance generate an index file so that this run(with a large
sort_area_size) after the import.
One thing as well is to use COMMIT=N which implies that the commit will only
occur ONCE for a 1 million rows table as of 1 million times if COMMIT=Y (my
Friend GovindanK will probably say COMMIT=Y is faster....We had a discussion
about his...:))

PS: it is important to always specify the database version you are using....
Regis

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Monday, December 30, 2002 5:29 PM
To: Regis Biassala
Cc: LazyDBA.com Discussion
Subject: RE: Resume IMPORT



Thank you very much.
Is there similar feature in Oracle 8i?

Regards,

Prasad.


Regis Biassala <Regis.[Email Address Removed]
12/30/02 05:10 PM

To: "LazyDBA.com Discussion" <[Email Address Removed]
cc:
Subject: RE: Resume IMPORT



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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
*********************************************************************
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