Скачать или смотреть Oracle DBA | Export & Import Schema By Using of Oracle Data Pump(With Tablespace) | Bangla | DBA2-04

Oracle DBA | Export & Import Schema By Using of Oracle Data Pump(With Tablespace) | Bangla | DBA2-04
To See More DBA part-01 Tutorial Click here    • Oracle DBA (Part-01) Tutorial For Beginners  
To See More DBA part-02 Tutorial Click here    • Oracle DBA (Part-2) Tutorial For Beginners  
To See More Reports Tutorial Click here    • Introduction To Database & Out Line The Se...  
To See More Forms Tutorial Click here    • Oracle Forms: How to Install Oracle Databa...  

Dear viewer, In this tutorial you will learn how to Export & Import Schema By Using of Oracle Data Pump (With Tablespace)


Step1:
Tablespeach Creation:
command-
conn sys
sql-create tablespace hr_tst datafile
'E:\app\Administrator\oradata\orcl\wali.DBF' size 500M;

Step2: User Creation:
command-
sql-create user abc identified by abc default tablespace tab1;
sql-grant dba to ab1;

Step3: Make a Directory:
command-
sql-create directory datap1 as 'E:\BACKUP_ALL\datapppppp';
sql-grant read,write on directory datap1 to hr;

Step4:
Export:
command-expdp hr/hr directory=datap1 dumpfile=dirfile.dmp

Step5:
Import:
Run cmd command- impdp ab1/ab1 DIRECTORY=datap1 DUMPFILE=dirfile.dmp
remap_schema=hr:ab1 REMAP_TABLESPACE=(example:hr_tst,users:hr_tst)

To Get more Tutorial Subscribe The Channel
click here    / @oracledbsolutions2678  

To Get All Post Like The Facebook Page
Click here   / oracledbsolutions  

Follow us:
Facebook:   / oracledbsolutions  
Youtube link:    / @oracledbsolutions2678  
Facebook Group:   / 465557066961548  

Contact us:
email: [email protected]
Skype: oracle26solutions
Mob: 01734557080, 01627422780