oracle备份数据库和恢复数据库

导出表
exp username/password@orcl file=d:\oracle.dmp

第一步：创建表空间
create tablespace user_data  
logging  
datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf' 
size 50m  
autoextend on  
next 50m maxsize unlimited
extent management local;  

第二步：创建临时表空间
create temporary tablespace user_temp  
tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf' 
size 50m  
autoextend on  
next 50m maxsize unlimited
extent management local;  

第三步：创建用户，并赋表空间
create user username identified by password  
default tablespace user_data  
temporary tablespace user_temp;  

grant connect,resource,dba to username;

grant session,create table,create procedure,create sequence,create trigger,create view,select any dictionary,create materialized view to username;

alter user username quota unlimited on tablespace;

imp username/password@orcl fromuser=system touser=username  file='d:\oracle.dmp' log='G:\database\gdjt\gdjt.log' buffer=100000  ignore=y