Oracle Database Tutorial 55: How to export tables using PARFILE in expdp Data Pump By Manish Sharma

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

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

50% 1

In this Oracle Tutorial you will learn how to export tables of the database using Parameter File (PARFILE) in Data Pump expdp export utility.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: bit.ly/expdp-parfile-table-mod...
Previous Tutorial
Tut 52 Expdp Full Database • Oracle Database Tutori...
Tut 53 Expdp Tablespace • Oracle Database Tutori...
Tut 54 Expdp Schema • 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

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

28 ноя 2014

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@rameshdoosa9075 8 лет назад

thank you so much Mr. Manish...

@EduFeastFamily 7 лет назад

Thank you, Manish...

@firstnamelastname8735 7 лет назад

Now I am feeling to learn ORACLE DBA easily and quick that help me in my job work. Will like to connect with you for further doubts as DBA fresher.

@maheshKumar-pu5hr 6 лет назад

simple and clear

@ushasubramanian8805 7 лет назад

Hi Manish, In a multi-tenant application, While exporting tables from a database , can we use filters in the Par file like for example: Schemaname.Table_name where Enterprise_id = 100

@shilpadorle595 8 лет назад

Hi Manish, Do indexes and constraints get copied automatically with table export or do have to explicitly do that?

@shrikant_goud 8 лет назад

Hey Manish, can we export/import stored procedure, functions too??? if yes, can u pls explain/ load a video for the same?

@vidmayur 8 лет назад

Hi Manish , while creating the par file it is stil showing as text file format instead of par format even after naming it to table.par . any fix for this ??

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

Hi Manish, I read your parfile article and it was interesting and gave more information about parameter file. I have a doubt regarding parameters specified in the parfile. Could we specify the parameters in parfile in any order or it should be as below. DIRECTORY = exp_table DUMPFILE = table.dmp LOGFILE = table_lg.log TABLES = employees, departments

@akshaykatke1259 5 лет назад

Hi Manish, I want to join 3 tables and want to exclude the first 3 records using exclude. Can you help me with it?

@avinashjain16 3 года назад

what should be the sequence of parameter in par file ? or sequence does not matter ? Second Ques : Is there any sequence to be followed while giving parameter in expdp utility without par file