HomeОбразованиеRelated VideosMore From: Manish Sharma

Oracle Database Tutorial 58: How To Import Schema using REMAP_SCHEMA in impdp Data Pump Import

130 ratings | 22047 views
Learn how to import schema using REMAP_SCHEMA in impd data pump import in oracle database By Manish Sharma Rebellion Rider. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/how-to-import-schema-impdp-data-pump-oracle Previous Tutorial Tut 56 How to import table in same schema : http://youtu.be/oEnmEUlicY0 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Html code for embedding videos on your blog
Text Comments (6)
Abid Niaz Malik (1 year ago)
Dear Good Job. Excellent explanation , no wastage of time. to the point. One more subscription added. Stay blessed stay happy , spread knowledge and love. Best Regards: PAKISTAN
mayur dubey (1 year ago)
HI Manish , how to import the schema on other database running on the same machine , example i have 2 databases ,first is orcl and other is orcl2 , i want to import the schema from orcl to orcl2 , can you please tell the steps Thanks
Jignesh Solanki (1 year ago)
Very information video Manish !! I was trying to use impdp command the same way you explained on the data dump already created by someone else. I get the following error: ORA-39083: Object type USER:"WEBDB" failed to create with error: ORA-65096: invalid common user or role name Failing sql is: CREATE USER "WEBDB" IDENTIFIED BY VALUES ..... It keeps going on... and finally says... Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 3753 error(s) at Fri Apr 28 16:36:41 2017 elapsed 0 00:01:08 === Could you please help me what is wrong? I am using the below command impdp system/[email protected] DIRECTORY=exp_schema DUMPFILE=EXP_SCHM_WEBDB.DMP LOGFILE=myimpdp3.log SCHEMAS=WEBDB Thank you !!
Deepak Das (3 years ago)
If I am exporting all schema's in to a single dump file and I want to import specific schema from that dump file.How do I do that?If I mention specific schema name in the import command will that throw any error?
Vinay M (4 years ago)
Hi Manish, can you tel me how to check that how many databases are there in the oracle (For example : I have created my won database this is also one DB in oracle now my question is i want to see all the DB names from the oracle) expecting help soon from you on this.
Manish Sharma (4 years ago)
+Vinay M just go to your command prompt and execute this command sc queryex type= service state= all | find /i "OracleService" this will return service name and the display name of  database services running on the server.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.