Roads ? - where we're going, we don't need roads ...
Sample config | ORA600
ORA600 content Content 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.

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

//VERSION="7" // only use for 7

// dude's block cache
BUFFERCACHE = "1000"
// database blocksize
BLOCKSIZE = "8192"

DICTIONARY_DIR = "/root/dude/dic"
SCAN_DIR = "/root/dude/scan"
LOG_DIR = "/root/dude/log"
DUMP_DIR = "/data/customer/flat"
PLSQL_DIR = "/root/dude/plsql"
SQLLDR_DIR = "/root/dude/sqlldr"
DDL_DIR = "/root/dude/ddl"
SCRIPT_DIR = "/root/dude/scan"
LOB_DIR = "/data/customer/lobs"
LOG_FILE = "dude.log"

// X platform unloading

/*

MAP_LOB_DIR="c:\\lobs"
MAP_DUMP_DIR="c:\\flat"
MAP_SQLLDR_DIR="c:\\sqlldr"
MAP_FILESEP="\\"

*/


PRETTY_FILE_NAMES="true"

AUTO_FILENUMBER="true"
AUTO_DICTIONARY="true"
AUTO_BLOCK_CHECK="true"

PLATFORM="INTEL"

PARTITIONING="true" // set to "true" if the database contains partitioned tables
ENABLE_LOBS="true" // set to "true" if the database contains LOB columns

HUGE_LOB_SUPPORT="false"

INCLUDE_DROPPED="false"

FLAG_FRACTURED_BLOCKS="true"
SKIP_FRACTURED_BLOCKS="false"
SKIP_OUT_OF_SYNC="false"

// autogenerate sqlldr controlfiles & ddl scripts
GEN_SQLLDR_CTL="true"
GEN_TABLE_DDL="true"

// Export Mode (false = flatfile, true = Oracle 805 DMP file)
EXPORT_MODE="false"
// the following parameters are evaluated when EXPORT_MODE="true"
EXPORT_FILE_SIZE="1048576000"
RECORDLENGTH="65536" /// "65536"
EXPORT_GZIP="false"
GZIP_BUFFER = "5242880"
EXPORT_NLS="WE8ISO8859P1"
EXPORT_NCHAR_NLS="UTF8"
// EOF EXPORT_MODE="true" parameters

// bootstrap$
/*
BOOTSTRAP_OBJ_OID      = "17" // "18"
BOOTSTRAP_COBJ_OID     = "1" // "2"
BOOTSTRAP_CUSER_OID    = "9" // "10"
BOOTSTRAP_TAB_TABNO    = "1"    // "1"
BOOTSTRAP_COL_TABNO    = "5"   // "5"
BOOTSTRAP_USER_TABNO   = "1"    // "1"
*/


// Generate recordset separator clause in SQLLDR controlfile
//(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="|||\n"   // RECORD SEPERATOR => IMPORTANT : if GEN_SQLLDR_STR_MODE=FALSE then you must set to "\n" for UNIX and "\r\n" for WINDOWS
FIELD_SEP="44"
FIELD_ENCL="255"
//FIELD_ENCL="34"
NULL_FIELD=""
FLAT_NLS="ISO8859_15"
SQLLDR_USE_CLOBFILE="false"

TABLESPACE "SYSTEM"
{
        DATAFILE="/data/ftp/customer/HTMLSUPPORT_WTWWW_01.DBF"
        ASSM="false"

}

TABLESPACE "HTMLSUPPORT"
{
        DATAFILE="/data/ftp/customer/HTMLSUPPORT_WTWWW_01.DBF"
        ASSM="true"
        BIGFILE="false"
        SAMPLE_LIMIT="100"
        SAMPLE_SIZE="100"
}

TABLESPACE "HTMLSUPPORT_LOB"
{
        DATAFILE="/data/ftp/customer/HTMLSUPOPRT_LOB_WTWWW_01.DBF"
        ASSM="true"
        BIGFILE="false"
        SAMPLE_LIMIT="100"
        SAMPLE_SIZE="100"
}

TABLESPACE "HTMLSUPPORT_WRKSPC"
{
        DATAFILE="/data/ftp/customer/HTMLSUPPORT_WRKSPC_WTWWW_01.DBF"
        ASSM="true"
        BIGFILE="false"
        SAMPLE_LIMIT="100"
        SAMPLE_SIZE="100"
}

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




Howto's
Check DUDE primer for info

Get Support

Worldwide support contact :
Henrik Bjerknæs Rasmussen
Service & Support Manager
Miracle AS
E-mail :
hra@miracleas.dk
Cell: +45 25 277 110

US support contact:
Daniel Fink
E-mail
daniel.fink@optimaldba.com
Cell : +1 303 808 32 82

Latin America support :
HBtec
E-mail
dude@hbtec.com.br
Cell : +55 47 88497639

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

Benelux only :
Kurt Van Meerbeeck
E-mail
dude@ora600.be
Cell : +32 495 580714