RE: Incremental Export in Oracle 9i

From: Hamid Alavi <hamid.alavi_at_quovadx.com>
Date: Fri, 4 Jun 2004 12:20:03 -0500
Message-ID: <C398496DF88AD711908C00065BEEE32CFE99F5@dfwmail.quovadx.com>

Thanks Joe for your input,
Appreciate your help & advice

-----Original Message-----

From: jtesta_at_dmc-it.com [mailto:jtesta_at_dmc-it.com] Sent: Friday, June 04, 2004 9:46 AM
To: Daniel.Fink_at_Sun.COM
Cc: jtesta_at_dmc-it.com; oracle-l_at_freelists.org Subject: Re: Incremental Export in Oracle 9i

My guess would be so that all of those exp scripts out there floating around don't bomb off with "invalid parameter" error but just ignore it and keep on running. No need to apologize, i rarely post except usually to be a smart ass but when i do post, i've already gone thru the procedure of proving the point so i dont look like a doofus posting errors :)

joe

Original message below

Joe,

Thank you. It's always nice to see someone take the time to prove what they say. My apologies for missing this on the list earlier.

It's curious...why would Oracle keep the parameter in exp and then tell you it is obsolete and it will be ignored? I'm sure they have a good reason, it just does not make much sense to this ol' dba...

Daniel

jtesta_at_dmc-it.com wrote:
Dan, I made the statement as its been stated in the 9i docs and to make you feel better here is your proof:

[oracle_at_linux tmp]$ exp jtesta full=y inctype=cumulative

Export: Release 9.2.0.5.0 - Production on Fri Jun 4 12:30:54 2004

Password:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.5.0 - Production
EXP-00041: INCTYPE parameter is obsolete

00041, 00000, "INCTYPE parameter is obsolete" // *Cause: Export encountered the INCTYPE parameter when parsing Export // options. Incremental Exports are no longer supported. // *Action: Consult the Oracle Backup and Recovery guide. // Export will attempt to continue. [oracle_at_linux tmp]$

Joe

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Fri Jun 04 2004 - 12:09:45 CDT