oracle如何导入数据库

以下是导入数据库的命令：

删除命名空间 drop tablespace CHINESE including contents and datafiles cascade constraints;
首先用户 drop user CHINESE cascade;
再执行，
CREATE TABLESPACE CHINESE--建立表空间
    LOGGING
    DATAFILE 'D:\app\Administrator\oradata\CHINESE\DEMO_20151015.DBF' SIZE 1G--单引号中的文件为随机文件，可以自行指定位置
    AUTOEXTEND ON NEXT 100M MAXSIZE 2G
    EXTENT MANAGEMENT LOCAL
    SEGMENT SPACE MANAGEMENT AUTO;

CREATE USER CHINESE--建立用户
    PROFILE DEFAULT
    IDENTIFIED BY CHINESE
    DEFAULT TABLESPACE CHINESE
    TEMPORARY TABLESPACE TEMP
    QUOTA UNLIMITED ON CHINESE
    ACCOUNT UNLOCK;

ALTER USER CHINESE DEFAULT ROLE  ALL;

GRANT CONNECT,
      CREATE PROCEDURE,
      CREATE TRIGGER,
      ANALYZE ANY,
      CREATE TYPE,
      SELECT ANY DICTIONARY,
      CREATE VIEW,
      CREATE SEQUENCE
TO CHINESE;

GRANT ALTER ANY TABLE TO CHINESE;
GRANT DROP ANY TABLE TO  CHINESE;
GRANT DELETE ANY TABLE TO  CHINESE;
GRANT SELECT ANY TABLE TO  CHINESE;
GRANT INSERT ANY TABLE TO  CHINESE;
GRANT CREATE ANY TABLE TO  CHINESE;
GRANT CREATE TYPE TO CHINESE;
GRANT CREATE PUBLIC DATABASE LINK TO CHINESE;
GRANT DROP PUBLIC DATABASE LINK TO CHINESE;
GRANT DBA TO CHINESE;

数据泵工具导出的步骤：
1、创建DIRECTORY
create directory DR_DBIMP as 'D:\DR_DBIMP';--导入的数据库所在的位置
2、授权
Grant read,write on directory DR_DBIMP to CHINESE;


以下这句话在“运行”中输入cmd后，执行；不是在sqlplus中执行
impdp CHINESE/CHINESE@CHINESE directory=DR_DBIMP DUMPFILE=DEMO_20151015.DMP LOGFILE=DEMO_20151015.log  REMAP_SCHEMA=(CS42DEMO:CHINESE) REMAP_TABLESPACE=(CS42DEMO:CHINESE)。
REMAP_SCHEMA=(CS42DEMO:CHINESE) REMAP_TABLESPACE=(CS42DEMO:CHINESE)，这句话冒号前边的是原来的用户和表空间，冒号后面的是现在建立的用户和表空间