You use expdp at the operating system command line to
start Export.
Export can unload data in a number of different modes, depending on what types of objects
you are exporting, from a single table to the entire database. The supported modes are Full Export,
Schema, Table, Tablespace, and Transportable Tablespace.
Full Export Mode
A full export uses the full parameter to the expdp command. The entire database is unloaded; you
must have the EXP_FULL_DATABASE role to export the entire database.
Schema Mode
You export one or more schemas with the schemas parameter in expdp; this is the default. If you
have the EXP_FULL_DATABASE role, you can export any schema; otherwise, you can export only
your own schema.
Table Mode
The table mode of expdp exports a specified set of tables; you use the tables parameter with
expdp. If you have the EXP_FULL_DATABASE role, you can export tables in any schema;
otherwise, you can only export tables in your own schema.
Tablespace Mode
You must have the EXP_FULL_DATABASE role to export an entire tablespace. Tablespace mode
is essentially shorthand for exporting all tables within one or more specified tablespaces. Any
dependent objects of tables that reside in the specified tablespaces are exported even if they
reside in another tablespace. You use the tablespaces parameter with the expdp command to
specify one or more tablespaces to export.
Transportable Tablespace Mode
Transporting a tablespace exports only the metadata for the objects within one or more tablespaces;
unlike tablespace mode, the objects within the tablespace must be completely self-contained.
Pages:
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873