Roads ? - where we're going, we don't need roads ...
Sample config | ORA600
ORA600 content Content RSS
Oracle ORA600 News RRSS Oracle News RSS
ORA600 blog Blog RSS
ORA600 blog Blog Atom

User login

Sample config

This is a sample of a DUDE config file.  

Upon receiving a DUDE.tar file - and after extracting the tar into a directory, create a file called dude.cfg in the directory where you have extracted the tar.

Then copy the contents from below into the dude.cfg file or just download it here.

//--------------- start copy here -------------------------------

 

 

/*********************************************************************/

/*                                                                   */

/*              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="" 

*/


 

 

// ---------- end here ------------------------




Howto's
See DUDE primer for info

Get Support

Europe

Belgium :
Kurt Van Meerbeeck
ORA600 bvba
E-mail
dude@ora600.be
Cell : +32 495 580714

Denmark :
Michael Môller
Service & Support Manager
Miracle AS
E-mail :
hra@miracleas.dk
Cell: +45 53 74 71 27


North America

USA :
Tim Gorman
Evdbt Inc
E-mail
tim@evdbt.com
Cell : +1 303 885 4526

Canada :
Pythian
E-mail
dude@pythian.com
Contact


Latin America

Brazil :
HBtec
E-mail
dude@hbtec.com.br
Cell : +55 47 88497639
Contact


Africa

South Africa :
Kugendran Naidoo
NRG Consulting
E-mail
k@nrgc.co.za
Cell : +27 82 7799275


East Asia Pacific

Australia
Andre Araujo
Pythian Australia
E-mail
dude@pythian.com
Cell : +61 2 9191 7427 ext. 1270