Original Export / Import

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 Resolve IMP-00029: cannot qualify table name by owner, use FROMUSER parameter

by Ed Chen
May 1, 2021May 2, 2021

Importing a dump file with table mode by imp, an original import, needs to be carefully handled, especially the table list. For example, we used… Read More »

How to Import Character Set Conversion

by Ed Chen
February 22, 2019December 10, 2022

Garbled Text Garbled data was found after importing a normal dump file. After doing some inspections, I found there's NLS_LANG environment variable for user oracle… Read More »