Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Incremental Export in Oracle 9i

Re: Incremental Export in Oracle 9i

From: <jtesta_at_dmc-it.com>
Date: Fri, 4 Jun 2004 12:45:47 -0400 (EDT)
Message-ID: <42895.155.188.255.3.1086367547.squirrel@www.dmc-it.com>


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

 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

 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
-----------------------------------------------------------------
Received on Fri Jun 04 2004 - 11:52:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US