oracle 备份文件 导入

创建临时表空间：
create temporary tablespace caitong_temp
tempfile 'D:\oracle\product\10.2.0\oradata\orcl\caitong\caitong_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;


删除表空间
drop tablespace caitong_temp including contents and datafiles cascade constraints;
drop tablespace caitong including contents and datafiles cascade constraints;


创建数据表空间
create tablespace caitong
logging
datafile 'D:\oracle\product\10.2.0\oradata\orcl\caitong\caitong.dbf'
size 100m
autoextend on
next 32m maxsize 2048m
extent management local;


创建用户：
create user ct identified by ct
default tablespace caitong temporary tablespace caitong_temp;

给用户授权：
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO ct;


导入备份文件：

C:\Documents and Settings\ibm>
imp user1/user1@orcl full=y file=d:\20100601ct.dmp ignore=y log=d:\log.txt
imp ct/ct@orcl full=y file=d:\20100601ct.dmp ignore=y log=d:\log.txt


imp user1/user1@orcl file=d:\20100601ct.dmp ignore=y log=d:\log.txt fromuser=sys touser=user1

查询用户下所有表的表名称：
select table_name from dba_tables where owner='user1'

select * from DQBG_REPORT