Oracle import IMP-00058 error and other

Oracle import IMP-00058 error and other

Oracle is used to access a project:

I. Download, install,

This is very careful and clear. You can do it later. Thanks to the author.

Http://blog.csdn.net/cxin917/article/details/50637891

Because I directly installed 32-bit oracle (I heard that 32-bit is more stable than 64, compatible or something)

The above connection tutorial is not done, and you can connect directly.

Ii. Import the database because my colleagues gave the dmp file and collected it, which is equivalent to backing up the database of SQL server.

At that time, oracle was installed with a virtual machine, which always generated 1017 errors or other errors. When an error was corrected, how could the Internet do it.

Therefore, the virtual machine is abandoned. Directly install the system.

In this case, go back to Step 1 and install the SDK.

3. After searching for a long time, we will talk about importing the. dmp file. If the file is exported in exp format, we need to use imp to import it. Of course, it is run in the cmd window.

Column: exp test/test @ test file = E: \ Oracle \ daochutest. dmp full = y

It is also said that the tablespace needs to be created before the import. It should be the same as exporting, or the Stored Procedure view may be lost.

The procedure is as follows:

Create tablespace test datafile 'e: \ Oracle \ test. ora 'size 500 m;
-- 1. Here, test is the tablespace name, and the path is named by itself. Click the execute button.


Create user test identified by test default tablespace test quota 500 m on users;
-- 2. Here, the first test is the user name, the second test is the password, and the third test is the tablespace name. Then execute.


-- 3. the permission granted to test is very high and can be exported.
Grant dba, connect, resource to test


-- 4 Delete the tablespace format:
Drop tablespace test
INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS


/*
Tablespace: name of the tablespace to be deleted
Including contents: delete all segments in the tablespace
And datafiles: deletes associated operating system files.
Cascade constraints: If a table outside the tablespace to be deleted references the master table in the tablespace
Delete the integrity constraints of the reference.
*/


Drop user test
-- 5. delete a user

Between 2 and 3, a table is created in test. For testing.

2. You cannot export data because you do not have the permission.

So 3 gave the permission. Dba

Then execute the command in cmd. The administrator I use is afraid that it will not work normally.

The exported file is as follows.

Exported successfully.

4. Try to import

1. Try to delete the tablespace. I want to see if there is no tablespace.

Then import the data, and an error is returned:

Reported: IPM-00058 error encountered 12154.

2. Recreate the tablespace:

Http://blog.csdn.net/xiaojin21cen/article/details/40077893

Create a tablespace.

2. Import again:

Imp test/test @ orcl file = E: \ Oracle \ daochutest. dmp full = y

The same error is reported. At this time, the user name and password do not exist.

Therefore, add users, grant permissions, and re-import

Import successful.

In addition, you can use toad to view the. dmp file.

Originally, I only wanted to export the items in test, and all the results were exported. It seems that when exporting, there were few parameters and improvements were needed.

After searching online, you only need to add the parameter onwer = test (current user) during export ), remove the full = y Statement (conflict will occur if you do not remove it)

I tried again today and found that if you export data with the dba permission, you must import the data with the dba permission. If you export data with a common user,

If you use the Account "system", you can create a tablespace even if you do not create a tablespace. However, general users rarely have system permissions. It is best to create a tablespace.

End the sprinkling.