Oracle创建表空间，授权，创建用户

一、前期

CREATE TABLESPACE zyebp1（表空间名）
LOGGING
DATAFILE ‘E:\TORACLE\APP\ORADATA\MLDN\zyebp1.DBF’–表空间的路径
SIZE 2M
AUTOEXTEND ON
NEXT 32M MAXSIZE 4096M
EXTENT MANAGEMENT LOCAL;–创建表空间，设置表空间的大小。

 select * from dba_data_files;--查询有哪些表空间。

 create user zyebp1 identified by zyebp1;--创建一个用户和密码。

 alter user zyebp1 default tablespace zyebp1;--把使用用户默认设置为使用zyebp1表空间。

ALTER USER zyebp1 QUOTA UNLIMITED ON zyebp1;–授权->
GRANT CREATE SESSION TO zyebp1;
GRANT CREATE CLUSTER TO zyebp1;
GRANT CREATE DATABASE LINK TO zyebp1;
GRANT CREATE ANY INDEX TO zyebp1;
GRANT CREATE ANY TABLE TO zyebp1;
GRANT CREATE ANY VIEW TO zyebp1;
GRANT SELECT ANY TABLE to zyebp1;
GRANT DELETE ANY TABLE to zyebp1;
GRANT UPDATE ANY TABLE to zyebp1;
GRANT INSERT ANY TABLE to zyebp1;
GRANT ALTER SYSTEM TO zyebp1;
GRANT DEBUG ANY PROCEDURE TO zyebp1;–<-授权

二、实操数据泵导入

1、创建表空间

2、创建用户

3、导入数据（sql）

impdp FHBE_xx/FHBE_xx directory=DUMP_DIR dumpfile=FHBE_xx0114.dmp remap_schema=FHBE_xx0104:FHBE_xx