Category Archives: oracle

Exp §Estimate max space needed select sum(bytes) from user_segments where segment_type=’TABLE’; §Exp comand •exp usr/pass PARFILE=filename §Parameters buffer=rows_in_array * max_row_sz (not applicable w/ direct=y) compress=y|n (y: one initial extent) consistent=n|y (y: large rbs, slower) constraints=y|n direct=n|y feedback=0 (progress meter) file=expdat.dmp, … Continue reading →