Importing data from Oracle

It's not the first time I got in touch with Oracle. I still installed it before and remotely connected to the server from PLSQL developer, but I never did it. This time, I gave a DMP file to be imported into the database. It took a lot of effort for the first contact and finally solved it with the help of others.

 

The process is like this. First open the Enterprise Manager Console, expand the database, find the storage node, and create a tablespace. The created tablespace name will eventually correspond to the space of the imported file, try again to see how it is consistent. If something goes wrong, you will see the name of the tablespace that should be created. Then create a user name for the DMP file to import. This is also based on the name displayed when the user is confused. When the user is created, the tablespace just created should correspond to the user, then execute this command. Just keep the path aligned.

 

IMP name/password @ oarcl file = A. dmp log = A. Log fromuser = OA touser = OA

 

Name/password is the username and password used to log on to the database, and CMDL is the Instance name. File: The DMP file fromuser is the tablespace of the user whose name touser is to be imported when exported from DMP. this is OK.

 

It took me most of the time. But I still learned it .~~

 

Note: If you do not have the sysdba permission, import

IMP 'name/password @ oarcl as sysdba 'file = A. dmp log = A. Log fromuser = OA touser = OA