Error information that we can not use IMP command to import the DMP database
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.
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.
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