imp

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 Resolve IMP-00038: Could not convert to environment character set's handle

by Ed Chen
September 2, 2020December 9, 2022

IMP-00038 I thought it was a character set conversion problem when using the original import (imp) to import a dump file, so I tried to… Read More »

How to Resolve ORA-01400: cannot insert NULL into

by Ed Chen
November 27, 2019May 29, 2023
2 Comments

ORA-01400 ORA-01400 means that there's a column which was found as NOT NULL is not listed in the INSERT statement, you have to provide a… 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 »

How to Resolve ORA-04043: object does not exist

by Ed Chen
December 30, 2017April 19, 2023

ORA-04043 ORA-04043 means that the schema object that you want to use is not existing, this could be a typo, privilege or case-sensitive problem like… Read More »

How to Resolve IMP-00401 Error Message

by Ed Chen
April 23, 2017October 24, 2021

IMP-00401: dump file may be an Data Pump export dump file When I use original import utility to import data from a dump file, I… Read More »

How to Resolve ORA-39143 Error Message

by Ed Chen
April 23, 2017October 24, 2021

ORA-39143: dump file may be an original export dump file Was trying to import the data using impdp, but it threw an error ORA-39143. ORA-39143:… Read More »

How to expdp AS SYSDBA without Password

by Ed Chen
May 13, 2016June 4, 2023
6 Comments

expdp AS SYSDBA Normally, we use system to migrate data from one to another, who has pretty enough privileges for all kinds of manipulation at… Read More »

What Oracle Command-line Utilities Need Authentication - Oracle

by Ed Chen
January 11, 2013December 11, 2022

Oracle provides many utilities to operate the infrastructure and database. Some of them need authentications to access database, but some don't. The bottom line is… Read More »

A Systematic Approach to Migrate Databases

by Ed Chen
December 21, 2012September 26, 2021

There are several kinds of database migration: Moving a database. It is to move a database to a more powerful server with the same version.… Read More »

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