Oracle Datapump EXPDP & IMPDP || sqlldr and External Table || Loading Data or Loading Data

preview_player
Показать описание
Data Pump offers many benefits and some new features over earlier data movement tools, such as:
1.Fine-grained object and data selection
2.Explicit specification of database version
3.Parallel execution
4.Estimation of export job space consumption
5.Network mode in a distributed environment
6.Remapping capabilities
8.Data sampling and metadata compression
9.Compression of data during a Data Pump export
10.Security through encryption
11.Ability to export XMLType data as CLOBs
12.Legacy mode to support old import and export files

#expdp #impdp #sqlldr #DataPump #DBLink #DataMove #DataLoading #ExternalTable #19c #Administration #Database #Exadata #RAC #ASM #Oracle

Please do follow me on,

Telegram Group: @mallik034
Skype: @malluramadurg

Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Рекомендации по теме
Комментарии
Автор

Thank you very much for this topic ..

Eira.
Автор

Hello Sir,

I have a doubt, A schema of size 300gb need to be exported & my directory doesn't have enough space. Is it possible to keep dumps in different directories and how to specify.

Thanks in Advance!

gokavarapuramganadeep
Автор

I have question
One dat file in this file like
Adders 1
End of address1
Address
End of address2

What is solution and using Sql loader

mtanish
Автор

Why don't you properly explain in Hindi
In English you're just reading it

Murtazakhan--