This site is intended to keep you up-to-date with the latest developments of DUDE.

DUDE (Database Unloading by Data Extraction) is a database unloader - it's able to bypass Oracle's database engine, extracting data directly at the block level.

This way, the database doesn't have to be up and running to unload data - what's more, DUDE is specifically designed to extract data when the database is down and/or corrupted.

It can be used for data that can not be retrieved any other way (even when you've lost your system tablespace). However, it should not be considered as a replacement for other Oracle utilities like sql*plus or exp/imp. It should be used as a last resort to recover your data, when everything else fails.

DUDE was also known as jDUL. jDUL refers to Oracle DUL (Data Unloader).

DUDE basically offers the same functionality as DUL in a multi-platform java environment.DUDE is a standalone java program - and therefore can be run on every platform supporting java (1.2.x or higher is recommended).

DUDE is available as a service or as a product.

I n most cases, loss of service can be fatal for a business - therefore, DUDE is also available as a product. This way, no valuable time is lost getting a consultant on-site, or uploading datafiles. T his option can - for example - be used for databases that contain sensitive data (credit card numbers, medical patient files) that should never leave your server.

A limited 'proof of concept' version is available on request.

Get started now !

jDUL/DUDE v 2 .6 .6 currently supports :

	creation of blockmap
	recreation of the Oracle dictionary
	autodetection of file number and blocksize of datafiles
	performing a describe of tables
	extracting tables based on object id or tablename
	extracting entire tablespaces
	extracting partitioned tables (including subpartitions)
	extracting PLSQL code (packages, procedures, functions, triggers, ...)
	generation of table DDL scripts
	generation of sequence DDL scripts
	generation of view DDL scripts
	heuristic scanning : in case of missing SYSTEM tablespace - tables, columns, and datatypes are guessed through sampling of datasets
	data can be extracted to : sql*loader flatfiles includes autogeneration of sql*loader controlfiles supports characterset encoding Oracle 8.0.5 compatible exp DMP files : multiple DMP file support (for filesystems with 2Gb limits) DMP files can be compressed on the fly in gzip format the 8.0.5 DMP's can be imported in 8.0.x, 8.1.x, 9.x.x and 10.x.x database using the imp utility
	all major intel & unix platforms are supported : windows, linux, IBM AIX, Sun Solaris/SunOS, HPUX, Tru64, Open VMS (on alpha)
	datatypes supported : NUMBER, CHAR, VARCHAR2, LONG, DATE, RAW, LONG RAW, BLOB, CLOB, TIMESTAMP (+9i) , BINARY FLOAT, BINARY DOUBLE (+10g)
	LOB support : CLOB & BLOB support - (both dumping to DMP format and flatfiles support) support for enable storage in row inline LOBs support for enable storage in row out-of-line LOBs support for disable storage in row LOBs support for chunk versions LOBs are only supported when SYSTEM is available
	supports Oracle RDBMS versions 7, 8.0, 8i, 9i,10g and 11g
	supports Oracle RDBMS versions migrated using the mig utility
	supports Oracle 10g BIGFILE tablespaces
	cross-platform unloading : for example unloading AIX based datafiles on a Windows host
	Compressed table blocks and 11g table compression (currently in beta)
	chained & migrated rows, trailing NULL columns, first free row index, intra-block chaining

	IOT's - index organized tables
	ASM support

What can be recovered :

How to get started ?