导入导出

导入命令：

1.cmd进入命令行；
	(1)无连接登录ora
	  sqlplus /nolog
	(2)管理员身份登录
	  conn system/system
	(3)删除旧用户
	  drop user xcgdzc cascade;
	(4)创建新用户
	  create user xcgdzc identified by xcgdzc;
	(5)给新用户授权
	  grant dba to xcgdzc;
2.Ctrl+C退出命令行；	
3.cmd进入命令行；执行以下命令导入数据库（注意：D:\workspace_GDZC\xcgdzc1110.dmp文件存在的情况下方可成功导入）
imp  xcgdzc/xcgdzc@lportal fromuser=xcgdzc touser=xcgdzc file=D:\workspace_GDZC\xcgdzc.dmp

导出命令：

exp xcgdzc/xcgdzc@lportal file=D:\workspace_GDZC\xcgdzc.dmp