创建临时表空间
create temporary tablespace transgd_temp tempfile 'D:\oracle\product\10.2.0\oradata\orcl\transgd_temp.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local;
创建表空间
create tablespace transgd_data logging datafile 'D:\oracle\product\10.2.0\oradata\orcl\transgd_data.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local;
创建用户并制定表空间
create user line identified by line default tablespace transgd_data temporary tablespace transgd_temp;
给用户授权
grant dba to line;
导入dmp文件(dos命令导入)
imp line/line@orcl full=y file=d:\transgd.dmp ignore=y;
导出dmp文件(dos命令导入)
exp line/line@orcl full=y file=c:\transgd.dmp;
删除用户
drop user line cascade;