Data pump exporting

root> su - oracle

oracle> export ORACLE_SID=venu

oracle> sqlplus / as sysdba

SQL> startup

 

root> su - oracle

oracle> export ORACLE_SID=venu

oracle> expdp dumpfile=sys.dmp logfile=sys.log

                username : / as sysdba

 

SQL> select count(*) from tab;

                Check for the tables before starting the job and after ending the job.

               

                default location :

                /u01/app/oracle/venu/dpdump/sys.dmp

                SQL> select * from dba_directories;

                oracle> cd /u01/app/oracle/venu/dpdump/

                oracle dpdump> ls

 

                different location :

                SQL> create directory dp as '/u03/dpdump';

                root> mkdir -p /u03/dpdump

                root> chown -R oracle:oinstall /u03/dpdump/

                root> chmod -R 775 /u03/dpdump/

                root> su - oracle

                oracle> export ORACLE_SID=venu