Oracle数据库导入

登录数据库
conn sys/sys as sysdba;
--删除用户
drop user jnzb cascade;
--创建新用户
1、create user
	create user zhanggc
	identified by zhanggc
	default tablespace users
	quota 10M on users
--为用户分配部分权限
2、grant create session,create table,create view,create sequence,create trigger to zhanggc
--导入数据库
3、import the data
********************或者***************************
--把所有权限赋给用户
grant connect,resource,dba to zhanggc

--打开PLSQL，右键点击Dabase links--->new...
在左侧name一栏中输入SHAOXING
然后Apply

选中SHAOXING.REGRESS.RDBMS.DEV.US.ORACL
选择Tools——>import tables