How to Export and Import Full Oracle Database using Datapump Utility.

preview_player
Показать описание
we can export ( expdp ) and import ( impdp ) Full Oracle Database using datapump utility.
we can use expdp for export and impdp for import.
In this video i am showing you how to export Full Oracle Database and how to import Schema, Tablespace, Tables, Viwes using Datapump utility.
It is very easy to understand.
Рекомендации по теме
Комментарии
Автор

Notes:
You must drop all non-system users like scott or others
Also it's good create all tablespaces of the source database in target database before the import (because the impdp try to create the tablespaces, but if the path of datafile in the tablespace not exists in the target, it will faill)

DaniloOliveiracanal
Автор

Can you help on below point?

UDI-12504: operation generated ORACLE error 12504
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

vinayaw
Автор

Change the title. It gives the wrong intention.

amilakasun
visit shbcf.ru