Original Export / Import

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

by Ed Chen
August 18, 2022June 8, 2023

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, 2022August 31, 2023
2 Comments

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, 2022August 31, 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, 2019April 19, 2023

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 »

JavaScript is not enabled. Please enable it and reload the page.