REM DDL Script to unload the dictionary cache for DUL V8 (Oracle 6)

REM force a standard unloading session, no unwanted settings
alter session set export_mode = false;
alter session set ldr_phys_rec_size = 0;
alter session set ldr_enclose_char = """" ;
alter session set file = "" ;

UNLOAD TABLE obj$ ( OBJ# NUMBER, OWNER# NUMBER, NAME VARCHAR2(30), TYPE NUMBER)
	STORAGE(SEGOBJNO 17 FILE 1);

UNLOAD TABLE TAB$( OBJ# NUMBER, TS# IGNORE, FILE# NUMBER, BLOCK# NUMBER,
	CLU# IGNORE, TAB# NUMBER, COLS NUMBER, CLUCOLS NUMBER)
	cluster  C_OBJ#(OBJ#)
	storage ( tabno 1 segobjno 1 file 1)
;

UNLOAD TABLE COL$ ( OBJ# NUMBER, COL# NUMBER , SEGCOL# NUMBER,
	SEGCOLLENGTH IGNORE, OFFSET IGNORE, NAME CHAR(30),
	TYPE# NUMBER, LENGTH NUMBER)
	cluster C_OBJ#(OBJ#)
	storage( tabno 5 segobjno 1 file 1)
;

UNLOAD TABLE USER$( USER# NUMBER, NAME VARCHAR2(30))
	cluster C_USER#(USER#)
	storage(tabno 1 segobjno 9 file 1)
;

REM restart and and load the just unloaded tables in my cache
exit