Export ‘ORACLE’ in Linux

Export

1.      sudo –i

2.      sudo su oracle

3.      cd

4.      export  ORACLE_SID=XE;

5.      export  ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server;

6.      export  PATH=$PATH:$ORACLE_HOME/bin;

7.      sqlplus

·        SQL*Plus: Release 10.2.0.1.0 - Production on
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Enter user-name: *****
Enter password: *****

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL>create directory dmpdir3 AS '/tmp';    
Directory created.

8.      expdp directory=[user path]  dumpfile=filename.dmp

              Export: Release 10.2.0.1.0 - Production on
              Copyright (c) 2003, 2005, Oracle.  All rights reserved.
              Username: *******
              Password: *********

              Connected to: 

              Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production