一、前期
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