Oracle data export and import Permissions

The following describes how to grant permissions to oracle data export and import. If you are interested in oracle data export, take a look.

Oracle data export exp wjcx/wjcx @ orcl file = wjcx. dmp the first is the user name, the second is the password, and the third is the host name
Import imp wjcx/wjcx @ orcl file = wjcx. dmp full = y the entire ignore = y indicates that the existing table is not imported.

Import imp wjcx/wjcx @ orcl file = wjcx. dmp tables = import a table

 
 

  
  
GRANT CONNECT TO   user   
  
  
GRANT CONNECT ,RESOURCE,DBA TO   user    
  
  
 
  
  
create tablespace wjcx  
  
  
logging  
  
  
datafile 'F:\oracle\product\10.2.0\oradata\orcl\wjcx01.dbf'  
  
  
size 32m  
  
  
autoextend on  
  
  
next 32m maxsize 2048m  
  
  
extent management local;  
  
  
 
  
  
ORCL =  
  
  
(DESCRIPTION =  
  
  
    (ADDRESS_LIST =  
  
  
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))  
  
  
    )  
  
  
    (CONNECT_DATA =  
  
  
      (SERVICE_NAME = orcl)  
  
  
    )  
  
  
)  
  
  
 
 
 

Oracle read-only user role creation

View oracle user permissions

Introduction to oracle object permissions

Three oracle authorizations

How to store images in oracle