导表

一、创建表空间：
CREATE TABLESPACE "MWS_SYS"
    LOGGING
    DATAFILE 'D:/ora/MWS_SYS.ora' SIZE 6000M
    AUTOEXTEND
    ON NEXT  100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
    SEGMENT SPACE MANAGEMENT  AUTO ;
  二、创建用户：    
    create user MW_SYS identified by sys default tablespace "MWS_SYS"
  三、授权：
    GRANT DBA TO MW_SYS WITH ADMIN OPTION    
    grant ALTER ANY CLUSTER to MW_SYS with admin option;
grant ALTER ANY DIMENSION to MW_SYS with admin option;
grant ALTER ANY INDEX to MW_SYS with admin option;
grant ALTER ANY INDEXTYPE to MW_SYS with admin option;
grant ALTER ANY LIBRARY to MW_SYS with admin option;
grant ALTER ANY OUTLINE to MW_SYS with admin option;
grant ALTER ANY PROCEDURE to MW_SYS with admin option;
grant ALTER ANY ROLE to MW_SYS with admin option;
grant ALTER ANY SEQUENCE to MW_SYS with admin option;
grant ALTER ANY SNAPSHOT to MW_SYS with admin option;
grant ALTER ANY TABLE to MW_SYS with admin option;
grant ALTER ANY TRIGGER to MW_SYS with admin option;
grant ALTER ANY TYPE to MW_SYS with admin option;
grant ALTER DATABASE to MW_SYS with admin option;
grant ALTER PROFILE to MW_SYS with admin option;
grant ALTER RESOURCE COST to MW_SYS with admin option;
grant ALTER ROLLBACK SEGMENT to MW_SYS with admin option;
grant ALTER SESSION to MW_SYS with admin option;
grant ALTER SYSTEM to MW_SYS with admin option;
grant ALTER TABLESPACE to MW_SYS with admin option;
grant ALTER USER to MW_SYS with admin option;
grant ANALYZE ANY to MW_SYS with admin option;
grant AUDIT ANY to MW_SYS with admin option;
grant AUDIT SYSTEM to MW_SYS with admin option;
grant BACKUP ANY TABLE to MW_SYS with admin option;
grant BECOME USER to MW_SYS with admin option;
grant COMMENT ANY TABLE to MW_SYS with admin option;
grant CREATE ANY CLUSTER to MW_SYS with admin option;
grant CREATE ANY CONTEXT to MW_SYS with admin option;
grant CREATE ANY DIMENSION to MW_SYS with admin option;
grant CREATE ANY DIRECTORY to MW_SYS with admin option;
grant CREATE ANY INDEX to MW_SYS with admin option;
grant CREATE ANY INDEXTYPE to MW_SYS with admin option;
grant CREATE ANY LIBRARY to MW_SYS with admin option;
grant CREATE ANY OUTLINE to MW_SYS with admin option;
grant CREATE ANY PROCEDURE to MW_SYS with admin option;
grant CREATE ANY SEQUENCE to MW_SYS with admin option;
grant CREATE ANY SNAPSHOT to MW_SYS with admin option;
grant CREATE ANY SYNONYM to MW_SYS with admin option;
grant CREATE ANY TABLE to MW_SYS with admin option;
grant CREATE ANY TRIGGER to MW_SYS with admin option;
grant CREATE ANY TYPE to MW_SYS with admin option;
grant CREATE ANY VIEW to MW_SYS with admin option;
grant CREATE CLUSTER to MW_SYS with admin option;
grant CREATE DATABASE LINK to MW_SYS with admin option;
grant CREATE DIMENSION to MW_SYS with admin option;
grant CREATE INDEXTYPE to MW_SYS with admin option;
grant CREATE LIBRARY to MW_SYS with admin option;
grant CREATE PROCEDURE to MW_SYS with admin option;
grant CREATE PROFILE to MW_SYS with admin option;
grant CREATE PUBLIC DATABASE LINK to MW_SYS with admin option;
grant CREATE PUBLIC SYNONYM to MW_SYS with admin option;
grant CREATE ROLE to MW_SYS with admin option;
grant CREATE ROLLBACK SEGMENT to MW_SYS with admin option;
grant CREATE SEQUENCE to MW_SYS with admin option;
grant CREATE SESSION to MW_SYS with admin option;
grant CREATE SNAPSHOT to MW_SYS with admin option;
grant CREATE SYNONYM to MW_SYS with admin option;
grant CREATE TABLE to MW_SYS with admin option;
grant CREATE TABLESPACE to MW_SYS with admin option;
grant CREATE TRIGGER to MW_SYS with admin option;
grant CREATE TYPE to MW_SYS with admin option;
grant CREATE USER to MW_SYS with admin option;
grant CREATE VIEW to MW_SYS with admin option;
grant DEBUG ANY PROCEDURE to MW_SYS with admin option;
grant DEBUG CONNECT SESSION to MW_SYS with admin option;
grant DELETE ANY TABLE to MW_SYS with admin option;
grant DROP ANY CLUSTER to MW_SYS with admin option;
grant DROP ANY CONTEXT to MW_SYS with admin option;
grant DROP ANY DIMENSION to MW_SYS with admin option;
grant DROP ANY DIRECTORY to MW_SYS with admin option;
grant DROP ANY INDEXTYPE to MW_SYS with admin option;
grant DROP ANY LIBRARY to MW_SYS with admin option;
grant DROP ANY OUTLINE to MW_SYS with admin option;
grant DROP ANY PROCEDURE to MW_SYS with admin option;
grant DROP ANY ROLE to MW_SYS with admin option;
grant DROP ANY SEQUENCE to MW_SYS with admin option;
grant DROP ANY SNAPSHOT to MW_SYS with admin option;
grant DROP ANY SYNONYM to MW_SYS with admin option;
grant DROP ANY TABLE to MW_SYS with admin option;
grant DROP ANY TRIGGER to MW_SYS with admin option;
grant DROP ANY TYPE to MW_SYS with admin option;
grant DROP ANY VIEW to MW_SYS with admin option;
grant DROP PROFILE to MW_SYS with admin option;
grant DROP PUBLIC DATABASE LINK to MW_SYS with admin option;
grant DROP PUBLIC SYNONYM to MW_SYS with admin option;
grant DROP ROLLBACK SEGMENT to MW_SYS with admin option;
grant DROP TABLESPACE to MW_SYS with admin option;
grant DROP USER to MW_SYS with admin option;
grant EXECUTE ANY INDEXTYPE to MW_SYS with admin option;
grant EXECUTE ANY LIBRARY to MW_SYS with admin option;
grant EXECUTE ANY PROCEDURE to MW_SYS with admin option;
grant EXECUTE ANY TYPE to MW_SYS with admin option;
grant FORCE ANY TRANSACTION to MW_SYS with admin option;
grant FORCE TRANSACTION to MW_SYS with admin option;
grant GLOBAL QUERY REWRITE to MW_SYS with admin option;
grant grant ANY OBJECT PRIVILEGE to MW_SYS with admin option;
grant grant ANY PRIVILEGE to MW_SYS with admin option;
grant grant ANY ROLE to MW_SYS with admin option;
grant INSERT ANY TABLE to MW_SYS with admin option;
grant LOCK ANY TABLE to MW_SYS with admin option;
grant MANAGE TABLESPACE to MW_SYS with admin option;
grant ON COMMIT REFRESH to MW_SYS with admin option;
grant QUERY REWRITE to MW_SYS with admin option;
grant RESTRICTED SESSION to MW_SYS with admin option;
grant SELECT ANY DICTIONARY to MW_SYS with admin option;
grant SELECT ANY SEQUENCE to MW_SYS with admin option;
grant SELECT ANY TABLE to MW_SYS with admin option;
grant UNDER ANY TABLE to MW_SYS with admin option;
grant UNDER ANY TYPE to MW_SYS with admin option;
grant UNDER ANY VIEW to MW_SYS with admin option;
grant UNLIMITED TABLESPACE to MW_SYS with admin option;
grant UPDATE ANY TABLE to MW_SYS with admin option;

 

其实这些可以写成一个.sql文件，“MW_SYS”可以用“&1”，然后，用一句话，去启动这个文件（比如说是grantToUser.sql），则，用“start  ...../grantToUser.sql   MW_SYS”, 运行的时候，MW_SYS会自动替代“&1”

 

四、导表：

imp SYSTEM/SYSTEM@SPMS  file='e:/PMS/hb0615.dmp'  FROMUSER 'MW_SYS' TOUSER 'MW_SYS'就可以了