No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade
Knowledge Base

The ORACLE failed to import data by IMP

Publication Date:  2012-09-24  |   Views:  309  |   Downloads:  0  |   Author:  SU1001522602  |   Document ID:  EKB1000015968

Contents

Issue Description

Error information that we can not use IMP command to import the DMP database

Alarm Information

The screen list the import table information, but do not import the data in table to the database, and inform us there already have been the import table.

Handling Process

1,Delete the former user’s ibill with table space.
2,Set up a new ibill table space, and assign the DBA permission.
3,Run IMP command and use ibll user log in to import the DMP to database
4,The setting “only list the content of the file”(yes/no) should choose no.

Root Cause

1,The VP8000 run the DBINSTALL exe file when installing, and have setup the user table to the database, so we failed to import DMP file from EXP, because it has exist.
2,When we run the IMP to import, the setting “only list the content of the file”(yes/no) should choose no, if we choose yes, only the table framework is list and read into the flash, no new user is set up.
3,Log in as the system/manager and run imp can import but failed to set up user table space, because the data is imported to system table space as we are system user.
4,Set up a new user IBILL, but still can not import as limited by the permission, assign the DBA permission will be OK

Suggestions

None