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 Beg...
To See More DBA part-02 Tutorial Click here • Oracle DBA (Part-2) Tutorial For Begi...
To See More Reports Tutorial Click here • Introduction To Database & Out Line T...
To See More Forms Tutorial Click here • Oracle Forms: How to Install Oracle D...
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