Datapump expdp/impdp utility.
Oracle gave two utilities like (exp and imp) and (expdp and impdp) to transport database. After 10g the traditional exp/imp become obsolete and additional method like expdp and impdp was introduced.
Datapump Export (expdp/ impdp)
This is also an ORACLE database external utility,that is used to transfer objects between databases. This utility is started from ORACLE 10g database. This utility also makes dump files of binary formats with database objects, object metadata and their control information. The expdp and impdp commands can be executed in the three ways followed:
Command line (specify expdp/impdp parameters in command line)
Parameter file (specify expdp/impdp parameters in a separate file)
Interactive- (entering various commands in export prompt)
There are five different modes of data unloading using expdp. They are:
- Full Export Mode (entire database)
- Schema Mode (default mode, specific schemas are exported)
- Table Mode (specified set of table and their dependent object)
- Tablespace Mode (the tables in the specified tablespaces are unloaded)
- Transportable Tablespace Mode (only the metadata for the table and their dependents object within a specified set of tablespace exported.)
Now do it of your own:
Create folder for wallet in $ORACLE_BASE/admin/SID/wallet
SID is the Database Name.
sqlnet.ora addition:
WALLET_LOCATION = (SOURCE=
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY=C:\oracle\product\10.2.0\admin\ORCL\wallet)
)))
CREATE OR REPLACE DIRECTORY dp_dir AS 'C:\Users\Administrator\Desktop\BK\';
SQL> alter system set key identified by test;
sytem altered.
Now you can able to using encryption_password parameter.
C:\oracle\product\10.2.0\db_2\bin\expdp scott/tiger@orcl DUMPFILE=scott.dmp DIRECTORY=dp_dir ENCRYPTION_PASSWORD=1234 SCHEMAS=scott
EXPORT IN LINUX:
su - oracle
export ORACLE_SID=orcl
sqlplus / as sysdba
ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK;
CREATE OR REPLACE DIRECTORY test_dir AS '/u01/app/oracle/oradata/orcl';
GRANT READ, WRITE ON DIRECTORY test_dir TO scott;
$ export ORACLE_SID=orcl
$ expdp scott/tiger schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expSCOTT.log