Settings for importing dmp files from Oracle databases

Oracle DatabaseHow to importDmp FileWhat about it? What are the settings required for import? This article introduces this process and hopes to help you.

1. delete user and user data (if the user and user data already exist)

Run the drop user CRM_USER cascade statement to delete tables and objects under the user and user name. If the prompt "oracle cannot delete the currently linked user" is displayed, follow these steps:

(1) view the user's connection status

 
 

  
  
select username,sid,serial# from v$session  
 
 

(2) locate the sid, serial, and delete the user to be deleted.

 
 

  
  
alter system kill session'135,288'   
  
  
 
  
  
alter system kill session'158,198'   
  
  
 
  
  
alter system kill session'139,1105'  
 
 

(3) Delete a user

 
 

  
  
drop user CRM_USER cascade 
 
 

(Additional) If you still prompt ORA-01940 after drop: Unable to delete the currently linked user, it means there is a connected session, you can check the session status to determine whether the session is killed, use the following statement to View Details:

 
 

  
  
select saddr,sid,serial#,paddr,username,status from v$session where username is not null 
 
 

If a user session is active, Repeat steps (2) and (3 ).

2. Create the CRM_USER in the Oracle Admin Console. The user roles and permissions are set as follows.

• Name CRM_USER
• Profile DEFAULT
• Authentication Password
• Default Tablespace mirin01
• Temporary Tablespace TEMP
• Status UNLOCK
• Default Consumer Group None

Roles

• Role Admin Option Default
• CONNECT N Y
• DBA N Y
• RESOURCE N Y

System Privileges

• System Privilege Admin Option
• CREATE MATERIALIZED VIEW N
• CREATE PROCEDURE N
• CREATE TABLE N
• CREATE TRIGGER N
• CREATE VIEW N
• DEBUG ANY PROCEDURE N
• DEBUG CONNECT SESSION N
• UNLIMITED TABLESPACE N

3. Import dmp files through PL/SQL

A. From CRM_USER to CRM_USER

B. Select the dmp File Location

C. Click Import to Import data.

In this way, the dmp file is imported successfully.

The process of importing the dmp file from the Oracle database ends here. I hope this introduction will be helpful to you!