Sample config | ORA600
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 ------------------------
Europe
Belgium :
Kurt Van Meerbeeck
ORA600 bvba
E-mail
dude@ora600.be
Cell : +32 495 580714
Denmark :
Henrik Bjerknæs Rasmussen
Service & Support Manager
Miracle AS
E-mail :
hra@miracleas.dk
Cell: +45 53 747 110
North America
USA :
Tim Gorman
Evdbt Inc
E-mail
tim@evdbt.com
Cell : +1 303 885 4526
USA :
Daniel Fink
OptimalDBA
E-mail
daniel.fink@optimaldba.com
Cell : +1 303 808 32 82
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
Alex Gorbachev
Pythian Australia
E-mail
dude@pythian.com
Cell : +61 2 9844 5431