Online Documentation for DB Extract for Oracle

Extract Options section


Section [#ExtractOptions#] stores values set on Step 7 of Wizard application.

 

The configuration parameters are listed below.

 

 

 

 

DropTableStmt

0 = Do not add DROP statements for the extracted objects

1 = Add DROP statements for the extracted objects to the result script

 

RecordsInBlock

The number of INSERT statements in a block after which the COMMIT statement is to be added

 

InsertCommit

0 = Do not insert COMMIT statement after each block

1 = Insert COMMIT statement after each block

 

DeleteAllRecords

0 = Do not delete any records from the tables before the INSERT statements

1 = Delete all records from the tables before the INSERT statements

 

Tablespaces

0 = Do not include definition of tablespaces into the extraction script

1 = Include definition of tablespaces into the extraction script

 

Privileges

0 = Do not include access privileges for the extracted objects

1 = Include access privileges for the extracted objects

 

ExtractDependentObjects

0 = Extract dependent objects

1 = Do not extract dependent objects

 

 

 

 

 

BlobExtractType

0 = Do not extract BLOB fields

1 = Extract BLOB fields to strings

2 = Extract BLOB fields into file

 

AddDateTimeToBlob

0 = Do not add the current date and time to BLOB filename

1 = Add the current date and time to BLOB filename

 

AddDateTimeTypeBlob

0 = Date will be added to BLOB filename

1 = Time will be added to BLOB filename

2 = Datetime will be added to BLOB filename