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.
//--------------- 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 ------------------------
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