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
See also: |