IMP_FULL_DATABASE

DATAPUMP_EXP_FULL_DATABASE, How and Why

by Ed Chen
November 21, 2022November 22, 2022

DATAPUMP_EXP_FULL_DATABASE DATAPUMP_EXP_FULL_DATABASE is one of predefined roles in Oracle database, who provides a bunch of system and object privileges required to perform full database exports… Read More »

How to Resolve IMP-00013: only a DBA can import a file exported by another DBA

by Ed Chen
August 18, 2022October 6, 2022

IMP-00013 IMP-00013 was reported by a normal user who want to import some data from other database. C:\Windows\system32>imp hr/password@orclpdb file=D:\dumps\hr.dmp ... ... IMP-00013: only a… Read More »

EXP_FULL_DATABASE, How and Why

by Ed Chen
August 17, 2022October 20, 2022

EXP_FULL_DATABASE EXP_FULL_DATABASE is one of predefined roles in Oracle database, who provides a bunch of system and object privileges required to perform full database exports… Read More »

IMP_FULL_DATABASE, How and Why

by Ed Chen
August 17, 2022March 20, 2023

IMP_FULL_DATABASE IMP_FULL_DATABASE is one of predefined roles in Oracle database, who provides a bunch of system and object privileges required to perform full database imports… Read More »

How to Use Data Pump Network Mode

by Ed Chen
March 11, 2013March 20, 2023

Data pump has a very nice feature since 10g, which can make data imported directly from source to target via network connection without any intermediate… Read More »