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, …
filesize=0[B|K|M|G]
full=n|y
grants=y|n
help=n|y
inctype=[complete|cumulative|incremental]
indexes=y|n
log=export.log
owner=
parfile=
query=
record=y|n
recordlength=
rows=y|n
statistics=estimate|compute|none
tables=
tablespaces=
(use w/ transport_tablespace)
transport_tablespace=n|y
triggers=y|n
userid=user/pass@sid
volsize=