/*********************************************************************/
/*                                                                   */
/*              Copyright (c) Kurt Van Meerbeeck 2001-2010           */
/*                                                                   */
/*********************************************************************/
/*                                                                   */
/* PROJECT TITLE  : DUDE (Database Unloader by Data Extraction)      */
/* PROJECT NUMBER : N/A                                              */
/*                                                                   */
/* MODULE NAME    : dude.cfg                                         */
/* VERSION        : 2.8.4                                            */
/*                                                                   */
/* AUTHOR         : Kurt Van Meerbeeck                               */
/* EMAIL    	   : kurtvm@pandora.be / dude@ora600.be               */
/*                                                                   */
/* WRITTEN        : 24-12-01                                         */
/*                                                                   */
/*********************************************************************/
/* For a quickstart guide - please visit :                           */
/*  http://www.ora600.be/faq-quickstart-dul                          */
/*                                                                   */
/* Detailed information can be found in the primer document at :     */
/*  http://www.ora600.be/DUDE_PRIMER.pdf                             */
/*                                                                   */
/* Unload scenario with SYSTEM available                             */
/*  See Addendum C - Quick start - SYSTEM available (primer doc)     */
/*                                                                   */
/* Unload scenario with SYSTEM not available                         */
/*  See Addendum D - Quick start - SYSTEM not available (primer doc) */
/*                                                                   */
/*********************************************************************/


/*********************************************************************/
/*                                                                   */
/*                           MAIN SECTION                            */
/*                                                                   */
/*********************************************************************/

// Oracle version
VERSION="92" // 7, 80, 81, 91, 92, 101, 102, 111, 112

// Database blocksize
// - common values : 2048, 4096, 8192, 16384
// - this parameter can also be set in the tablespace clause (see below)
// - DUDE will warn you at startup if this parameter is not set correctly
BLOCKSIZE="8192"

// DUDE's internal buffercache (number of blocks)
BUFFERCACHE = "1000"

// The following directories *must* exist
// - use double backward slashes on windows (ex. c:\\dump)
// - use single forward slashes on linux/unix (ex. /data/dump)
SCAN_DIR = "c:\\dude_scan"
LOG_DIR = "c:\\dude_log"
DUMP_DIR = "c:\\dude_flat"
PLSQL_DIR = "c:\\dude_plsql"
SQLLDR_DIR = "c:\\dude_ctl"
DDL_DIR = "c:\\dude_ddl"
SCRIPT_DIR = "c:\\dude_scan"
LOB_DIR = "c:\\dude_lobs"
DICTIONARY_DIR = "C:\\dude_dic" 

// Logfile name
LOG_FILE = "dude.log"

// Platform the database was created on
PLATFORM="INTEL"  // INTEL/AIX/SOLARIS/HPUX/TRU64/VMS

// Automatically generate table ddl scripts
GEN_TABLE_DDL="true"

// Set to "true" if the database contains partitioned tables
PARTITIONING="true"
// Set to "true" if the database contains LOB columns 
ENABLE_LOBS="true" 
// Set to "true" if the database contains LOB columns larger 
// than 500Mb 
HUGE_LOB_SUPPORT="false"



/*********************************************************************/
/*                                                                   */
/*                    OUTPUT GENERATION OPTIONS                      */
/*                                                                   */
/*********************************************************************/

// Export Mode (false = flatfile, true = Oracle 805 DMP file)
EXPORT_MODE="true" 

//------------------------- EXPORT_MODE=true ------------------------
// the following parameters are evaluated when EXPORT_MODE="true"

EXPORT_FILE_SIZE="10737418240" // max size of dmp in bytes (10Gb)
RECORDLENGTH="65536" // do not change
// if record doesn't fit in RECORDLENGHT then increment the buffer by
EXPORT_BUFFER_INCR="10485760" 

// gzip dump files on-the-fly
EXPORT_GZIP="false"
GZIP_BUFFER = "5242880"

// NLS characterset/codepage of DMP
// *must* match database characterset
EXPORT_NLS="WE8ISO8859P1"
EXPORT_NCHAR_NLS="AL16UTF16"

//----------------------- EXPORT_MODE=false -----------------------
// the following parameters are evaluated when EXPORT_MODE="false"

// Automatically generate sqlldr control files
GEN_SQLLDR_CTL="true"

// Generate recordset separator clause in SQLLDR controlfile 
// aka sql loader stream mode
// IMPORTANT
//  - this is only supported in sqlldr 8.1.6 and higher!
//  - Set to "false" if loading into Oracle 8.0.x
GEN_SQLLDR_STR_MODE="true"  
                            

// RECORD_SEP (RECORD SEPERATOR) ***IMPORTANT**** 
// if GEN_SQLLDR_STR_MODE=FALSE then you *must* set 
// RECORD_SEP to "\n" for UNIX and "\r\n" for WINDOWS
RECORD_SEP="||\r\n"   

// Flat file field seperator character
// ASCII decimal - example 44 equals a comma ',' 
FIELD_SEP="44"
// Flat file field enclosure character
// ASCII decimal - example 34 equals a double quote '"'
FIELD_ENCL="34"
// Null field string (leave as is for sqlldr)
NULL_FIELD=""
// Flatfile codepage
//  - see http://java.sun.com/j2se/1.3/docs/guide/intl/encoding.doc.html
//    for possible encodings
//  - codepage must match as close as possible database character set
FLAT_NLS="ISO8859_1"

/*********************************************************************/
/*                                                                   */
/*                        CORRUPTION HANDLING                        */
/*                                                                   */
/*********************************************************************/

// flag fractured blocks
FLAG_FRACTURED_BLOCKS="true"

// skip row entries that point to nowhere because of block fracture
SKIP_OUT_OF_SYNC="false"

// skip entire block because of block fracture
SKIP_FRACTURED_BLOCKS="false"

// also dump deleted records from base dictionary tables when dumping
// the dictionary
// - can be used for dropped tables
INCLUDE_DROPPED="false"

/*********************************************************************/
/*                                                                   */
/*                        BOOTSTRAP PARAMETERS                       */
/*                                                                   */
/*********************************************************************/

// Should only be set in rare cases
// please refer to "chapter 7 - the migrated dictionary" in the 
// primer doc

/*
BOOTSTRAP_OBJ_OID      = "279359" // "18"
BOOTSTRAP_COBJ_OID     = "2" // "2"
BOOTSTRAP_CUSER_OID    = "10" // "10"
BOOTSTRAP_TAB_TABNO    = "1"    // "1"
BOOTSTRAP_COL_TABNO    = "5"   // "5"
BOOTSTRAP_USER_TABNO   = "3"    // "1"

BOOTSTRAP_SOURCE_OID="32"

BOOTSTRAP_FILE_OID	    = "17" 
BOOTSTRAP_CFILEBLOCK_OID     = "8" 
BOOTSTRAP_CTS_OID      = "6" 
BOOTSTRAP_IND_TABNO    = "19" 
BOOTSTRAP_ICOL_TABNO   = "4" 
BOOTSTRAP_SEG_TABNO    = "2" 
BOOTSTRAP_TS_TABNO     = "2" 

*/

/*********************************************************************/
/*                                                                   */
/*                        X-PLATFORM PARAMETERS                      */
/*                                                                   */
/*********************************************************************/

// Should only be set when the following conditions are true
// - you are dumping to flatfiles
// - you are dumping a unix/linux on windows or vice versa
// - you are loading the data on the original platform
// Please refer to "chapter 3.7 Cross platform parameters" in the
// primer doc
//MAP_LOB_DIR="/lobs"
//MAP_DUMP_DIR="/dump"
//MAP_SQLLDR_DIR="/sqlldr"
//MAP_FILESEP="/"

// Generates unix friendly filenames
// For example - some schema or tablenames might contain a dollar '$'
// sign.
// Filenames inherit schema and tablenames - so in unix, a '$' sign
// makes it difficult to handle these files. 
// Setting the parameter to true, replaces the '$' character with the
// underscore '_' character in the filenames
PRETTY_FILE_NAMES="true"

/*********************************************************************/
/*                                                                   */
/*                     AUTOMATIC COMMANDS AT INIT                    */
/*                                                                   */
/*********************************************************************/

// These are legacy parameters and shouldn't be touched
AUTO_FILENUMBER="true"
AUTO_DICTIONARY="true"
AUTO_BLOCK_CHECK="true"

/*********************************************************************/
/*                                                                   */
/*                     SEGMENT HEADER/PAGETABLE USAGE                */
/*                                                                   */
/*********************************************************************/

// Instructs DUDE to use the segment header and pagetable blocks to
// use Oracle's extentmap in favor of using DUDE's own blockmap
// - Should only be used when no heavy physical corruption has occured
// - Increases speed of the unload as no blockmap of the tablespace
//   is needed
USE_SEGMENT_HEADER="false"
// Recreate the extentmap every time the segment is unloaded or reuse
FORCE_CREATE_EMAP="false"
// Multiblock read count [in blocks]
MBRC="16"

/*********************************************************************/
/*                                                                   */
/*                     TABLESPACE SPECIFIC PARAMETERS                */
/*                                                                   */
/*********************************************************************/

// Valid keywords are : 
// - DATAFILE 
//              specifies the datafile and location - this *must* 
//              exactly with the DATAFILE parameter in dude_probe.cfg
// - SAMPLE_LIMIT & SAMPLE_SIZE 
//              only needed for SCAN commands in case of missing 
//              SYSTEM tablespace or BOOTSTRAP command
//              in case of a migrated dictionary
// - ASSM      
//              automatic segment space management - always false for
//              SYSTEM. If you are not sure you can toggle the 
//              parameter without problems and try again
//              The command SHOW TABLESPACES FROM DICTIONARY will also
//              show you if the tablespace was created with ASSM or not
// - BLOCKSIZE
//              specifies tablespace specific blocksizes
// - BIGFILE
//              if the tablespace is a BIGFILE tablespace you should 
//              set this parameter to true

TABLESPACE "SYSTEM"
{
	DATAFILE="C:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\KVMB\\SYSTEM01.DBF"
	
	SAMPLE_LIMIT="100"
	SAMPLE_SIZE="100"
	
	ASSM="false"
}


TABLESPACE "EXAMPLE"
{
	DATAFILE="C:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\KVMB\\EXAMPLE01.DBF"

	SAMPLE_LIMIT="100"
	SAMPLE_SIZE="100"

	ASSM="true"

	BLOCKSIZE="8192"
}



/*********************************************************************/
/*                                                                   */
/*              Transparent Data Encryption (TDE)                    */
/*                                                                   */
/*********************************************************************/

// For future use
/*
// set to "true" if you use TDE
ENABLE_TDE="true" 
TDE_WALLET = "c:\\oracle\\product\\10.2.0\\admin\\kvmb\\wallet\\ewallet.p12"
TDE_WALLET_PASSWORD="kvmb" 
// leave empty if the wallet only contains one private key
TDE_PRIVATE_KEY_ALIAS="" 
*/