Oracle Database Tutorial 54: How to Export Schemas in Oracle Database (expdp Data Pump Export)

Подписаться 109 тыс.

Просмотров 58 тыс.

50% 1

Oracle / SQL tutorial 54 Data Pump expdp Export Schema Mode- How to export Schema in Oracle Database. Learns how you can export schema such as Scott,Hr and OE in oracle Database By Manish Sharma (RebellionRider)
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: bit.ly/how-to-export-schema-us...
Previous Tutorial
Tut 53 Expdp Tablespace • Oracle Database Tutori...
Tut 52 Expdp Full Database • Oracle Database Tutori...
-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
copy.com?r=kb4rc1
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
--------------------------------------------------------------------------
Amazon Wishlist: bit.ly/wishlist-amazon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
/ rebellionrider
/ imthebhardwaj
/ rebellionrider
plus.google.com/+Rebellionrider
/ mannbhardwaj
/ rebellionrider
/ rebellionrider
You can also Email me at
RebellionRiderYT@gmail.com
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

Опубликовано:

24 ноя 2014

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@wenzhongmo5731 9 лет назад

Very good tutorials! It is very helpful to transition my Sybase knowledge to Oracle. Unlike most of the technical tutorials, yours are very clear with the screen zoom-in feature. I would highly recommend to other people. The tutorials are good for beginners as well as for people with experience in other databases. It is quite easy to follow - I have spent 5-6 hours each day for three days to go through tutorial 1 to 54 with all the hands-on practices - from installation to write all queries. Thank you very much!!! (Will copy this comments to the tutorial 1 to help other people.) I have tried to follow the steps in the last two tutorials by using "hr" account to run expdp on "xe" - the default (schema ???) from the installation. But, it kept telling me "hr" doesn't have sufficient privilege. Finally, I used "system" account to run it successfully. I tried to follow the steps in this tutorial to dump schema "hr" or "xe". It said that there were no correspond to any schemas. Can you talk about the definitions of database schema and tablespace in Oracle and how to create schemas? Please tell me if you have already covered these topics in later tutorials.

@Sarg1422 7 лет назад

Thanks Manish. i have been searching online resource regarding EXP/IMP utilities, this is one of the most appropriate and best explained tutorial videos. thanks again and please keep posting.

@robertmugerwa6492 8 лет назад

Great Job and may God bless you.

@JustinLonas 7 лет назад

Love the energy you put out! :)

@robertmugerwa6492 8 лет назад

Good for knowledge shared is the mother of success.

@josuecuellosolorin1963 Год назад

excellent video. very helpful. thanks

@CarlosGarcia-di3kn 9 лет назад

very good tutorial Thanks

@nelsongarcia3356 7 лет назад

thanks you from dominica republic mr manish

@shekarsiripalli6342 9 лет назад

hai,manish please do some videos on table spaces,indxes,synonyms,triggers it would help us and thanks for your tutorials.

@damasiosabino1943 9 лет назад

Greetings Manish! Sorry write only now in my 54th video but I was so exciting learning that I left the comments for another time (now). As others said, feel free to make videos more explicit regarding the "basic" topics for us and please, sometimes you go deeper explaining things when the topic has other videos (for example at 2nd), so if you could be as explicit on these one video topics as on those with more than one, will be greater. Thank you for your time and patience!

@jenkinxander1139 8 лет назад

please do tutorial on stored procedures and sub queries, im sure, urs will be best...

@afsarbazmi289 Год назад

Hi Manish...thanks, It was helpful, Could you please suggest if there is space issue on the server In that case how to perform export.

@Clashing_Clans 2 года назад

please make a video on what are tablespaces and how to create them

@sandeepjha5098 9 лет назад

Please explain tablespace also in detail.Thanks

@pandachanchal 8 лет назад

Manish, if you have any video on tablespace please share the link. If not, please create one. Love your work man, thanks a bunch.

@Rebellionrider 8 лет назад

+chanchal panda Thanks for writing to me. I have a done a series of tutorial on Tablespaces. Here are the Links Tablespace In Oracle Database Introduction: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5i5RtUdxaHY.html How To Create Permanent tablespace: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vkwKZIssvfc.html How to create temporary tablespace: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Hc_OXitKgWM.html How To Create Undo Tablespace: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HlSrHX7ffbI.html How to create Tablespace using SQL Developer: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sDx9UPREdJ0.html Hope you will enjoy watching. Don't forget to help other in learning by sharing the content also make sure to Like the videos. Thanks

@pandachanchal 8 лет назад

Thnx mate...

@subarucj 7 лет назад

Thanks for your videos, but please use a Linux OS :)

@hussainsadikot8021 9 лет назад

hi there Manish one thing can you make clear here that if my database is in 8i and want to migrate all schema in 11g then quition is can i perform this operation in 8i and that case what should i do?

@govindadongol6021 9 лет назад

Can you also share what an exported schema looks like? I am working with an enterprise database with a LOT of tables but still I want to understand the relationship between tables. I tried to get the schemas for databases but it was very difficult to understand. Some tables have no relationship at all.