Only users with the DBA
role or the EXP_FULL_DATABASE
role can export in full database mode. In this example, an entire database is exported to the file dba.dmp
with all GRANTS
and all data.
Parameter File Method
> exp PARFILE=params.dat
The params.dat
file contains the following information:
FILE=dba.dmp GRANTS=y FULL=y ROWS=y
Command-Line Method
> exp FULL=y FILE=dba.dmp GRANTS=y ROWS=y
Export Messages
Information is displayed about the release of Export you are using and the release of Oracle Database that you are connected to. Status messages are written out as the entire database is exported. A final completion message is returned when the export completes successfully, without warnings.