导入:
第一、在导入sql和dmp文件之前,先建立用户,指明表空间。其中要注意用户名和表控件最好跟sql文件中的一样。
--2.create tablespace
create tablespace jwcenter
logging
datafile 'E:\app\Administrator\oradata\orcl\jwcenter.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
-- 3.Create the user
create user jwcenter
identified by "123456"
default tablespace jwcenter
temporary tablespace TEMP;
-- 4.Grant/Revoke role privileges
grant dba to jwcenter with admin option;
grant resource to jwcenter with admin option;
grant connect to jwcenter with admin option;
5.删除用户
drop user jwcenter cascade;
DROP TABLESPACE jwcenter INCLUDING C