Oracle Database 10g full database export .

http://sabdarsyed.blogspot.qa/2006/12/to-take-full-database-export-oracle-10g.html Step 1 Create a Export Directory: On Windows: ----------- SQL> create or replace directory sys_dmp as 'D:\expdp'; Directory created. On Solaris: ----------- SQL> create or replace directory sys_dmp as '/u02/expdp'; Directory created. Step 2 Create a separate export user: ############################## SQL> Connect /as sysdba SQL> CREATE USER expdpadmin IDENTIFIED BY expdp default tablespace users; User created. Step 3 Grant Export and Import Privileges. ################################### SQL> GRANT CONNECT,RESOURCE TO expdpadmin; Grant succeeded. SQL> GRANT exp_full_database to expdpadmin; Grant succeeded. SQL> alter user expdpadmin quota unlimited on USERS; User altered. SQL> GRANT READ, WRITE ON DIRECTORY SYS_DMP to expdpadmin; Grant succeeded. To check on which directories you have privilege to read & write: ################################################################# SQL> SELECT privilege, directory_name 2 FROM user_tab_privs t, all_directories d 3 WHERE t.table_name(+)=d.directory_name 4 ORDER BY 2,1; Step 4 Exporting Full Database: ######################## expdp expdpadmin/XXXXXX full=y directory=sys_dmp dumpfile=full_db_expdp.dmp logfile=full_db_expdp.log