| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Incremental Export in Oracle 9i
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
> I have not tried an incremental export in 9i, but it appears that the
> parameter controlling incrementals still exists. That's enough for me
> to ask the person making the statement to prove it.
>
> Regards,
> Daniel Fink
>
> exp help=y
>
> Export: Release 9.2.0.3.0 - Production on Fri Jun 4 10:14:22 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
>
> You can let Export prompt you for parameters by entering the EXP
> command followed by your username/password:
>
> Example: EXP SCOTT/TIGER
>
> Or, you can control how Export runs by entering the EXP command followed
> by various arguments. To specify parameters, you use keywords:
>
> Format: EXP KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
> Example: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
> or TABLES=(T1:P1,T1:P2), if T1 is partitioned table
>
> USERID must be the first parameter on the command line.
>
> Keyword Description (Default) Keyword Description (Default)
> --------------------------------------------------------------------------
> USERID username/password FULL export entire file
> (N) BUFFER size of data buffer OWNER list of owner
> usernames FILE output files (EXPDAT.DMP) TABLES list of
> table names COMPRESS import into one extent (Y) RECORDLENGTH length of
> IO record GRANTS export grants (Y) INCTYPE incremental
> export type INDEXES export indexes (Y) RECORD track
> incr. export (Y) DIRECT direct path (N) TRIGGERS
> export triggers (Y) LOG log file of screen output STATISTICS
> analyze objects (ESTIMATE) ROWS export data rows (Y) PARFILE
> parameter filename CONSISTENT cross-table consistency(N)
> CONSTRAINTS export constraints (Y)
>
> OBJECT_CONSISTENT transaction set to read only during object export
> (N) FEEDBACK display progress every x rows (0)
> FILESIZE maximum size of each dump file
> FLASHBACK_SCN SCN used to set session snapshot back to
> FLASHBACK_TIME time used to get the SCN closest to the specified
> time QUERY select clause used to export a subset of a
> table RESUMABLE suspend when a space related error is
> encountered(N) RESUMABLE_NAME text string used to identify
> resumable statement RESUMABLE_TIMEOUT wait time for RESUMABLE
> TTS_FULL_CHECK perform full or partial dependency check for TTS
> VOLSIZE number of bytes to write to each tape volume
> TABLESPACES list of tablespaces to export
> TRANSPORT_TABLESPACE export transportable tablespace metadata (N)
> TEMPLATE template name which invokes iAS mode export
>
> Export terminated successfully without warnings.
> 3
>
> Hamid Alavi wrote:
>> List,
>>
>> Yesterday somebody from list told me that we don't have Incremental
>> Export any more in Oracle 9i, any idea what's the option we could use
>> instead of this?
>> Any better feature?
>>
>> Hamid Alavi
>>
>> Office : 818-737-0526
>> Cell phone : 818-416-5095
>>
>> ----------------------------------------------------------------
>> 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
> -----------------------------------------------------------------
-- 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:30:39 CDT
 |
 |