1. Logon to Operating System with SIDADM on Windows, or ORASID on Linux/Unix Systems.
2. Create a logical directory definition where Oracle EXPSP tool will export Table Data
sqlplus "/as sysdba"
SQL> CREATE OR REPLACE DIRECTORY test_dir AS 'd:\';
3. Grant permission to AS Java Schema User to use Export Directory
SQL> GRANT READ, WRITE ON DIRECTORY test_dir TO SAPSR3;
4. Get list of tables to be exported. For e.g.
/FITE/INV_1_T001 |
/FITE/INV_1_T002 |
... /FITE/INV_1_T00n |
5. Execute the following command to export the tables data.
expdp SAPSR3@SED.WORLD INCLUDE=TABLE:"LIKE'%/FITE/INV%'" directory=test_dir dumpfile=FITEINVABAPTABLES.dmp logfile=expdpFITEINVABAPTABLES.log COMPRESSION=ALL REUSE_DUMPFILES=Y
Here;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
9 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |