Exp
\n\u00a7Estimate max space needed
\nselect sum(bytes)
\nfrom user_segments
\nwhere segment_type=’TABLE’;<\/p>\n
\u00a7Exp comand
\n\u2022exp usr\/pass PARFILE=filename<\/p>\n
\u00a7Parameters
\nbuffer=rows_in_array * max_row_sz
\n(not applicable w\/ direct=y)<\/p>\n
compress=y|n
\n(y: one initial extent)<\/p>\n
consistent=n|y
\n(y: large rbs, slower)<\/p>\n
constraints=y|n<\/p>\n
direct=n|y<\/p>\n
feedback=0
\n(progress meter)<\/p>\n
file=expdat.dmp, …<\/p>\n
filesize=0[B|K|M|G]<\/p>\n
full=n|y<\/p>\n
grants=y|n<\/p>\n
help=n|y<\/p>\n
inctype=[complete|cumulative|incremental]<\/p>\n
indexes=y|n<\/p>\n
log=export.log<\/p>\n
owner=<\/p>\n
parfile=<\/p>\n
query=<\/p>\n
record=y|n<\/p>\n
recordlength=<\/p>\n
rows=y|n<\/p>\n
statistics=estimate|compute|none<\/p>\n
tables=<\/p>\n
tablespaces=
\n(use w\/ transport_tablespace)<\/p>\n
transport_tablespace=n|y<\/p>\n
triggers=y|n<\/p>\n
userid=user\/pass@sid<\/p>\n
volsize=<\/p>\n","protected":false},"excerpt":{"rendered":"
Exp \u00a7Estimate max space needed select sum(bytes) from user_segments where segment_type=’TABLE’; \u00a7Exp comand \u2022exp usr\/pass PARFILE=filename \u00a7Parameters 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