oracle导入导出用户,Oracle 导入导出 创建用户等

还需要进行空表设置

owner 能导出空表

exp [email protected] owner=ss_sc_manager file=d:\2017048备份.dmp

imp [email protected] file=d:\2017048备份.dmp

、、、、、、、、、、、、、、、、、、、、、

创建表 空间等

CREATE TABLESPACE SS_SC_DB

DATAFILE ‘D:\SS_SC_DB.DBF‘ size 10240M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

--索引表空间

CREATE TABLESPACE SS_SC_DB_Index

DATAFILE ‘D:\SS_SC_DB_Index.dbf‘ size 512M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create temporary tablespace SS_SC_DB_temp

tempfile ‘d:\SS_SC_DB_temp.dbf‘

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

--2.建用户

create user ss_sc_db_manager identified by khdzkehai

default tablespace SS_SC_DB

temporary tablespace SS_SC_DB_temp;

--3.赋权

grant connect,resource to ss_sc_db_manager;

grant create any sequence to ss_sc_db_manager;

grant create any table to ss_sc_db_manager;

grant delete any table to ss_sc_db_manager;

grant insert any table to ss_sc_db_manager;

grant select any table to ss_sc_db_manager;

grant unlimited tablespace to ss_sc_db_manager;

grant execute any procedure to ss_sc_db_manager;

grant update any table to ss_sc_db_manager;

grant create any view to ss_sc_db_manager;

原文：http://www.cnblogs.com/llhhll/p/6727899.html