Oracle数据库备份还原相关语句

创建临时表空间：

create temporary tablespace coreqi_temp
tempfile 'D:\oracle\data\coreqi_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

创建数据表空间：

create tablespace coreqi_data
datafile 'D:\oracle\data\coreqi_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

创建用户并指定默认表空间和临时表空间

create user coreqi identified by 1 default tablespace coreqi_data  temporary tablespace coreqi_temp; 

授权新用户

Grant connect,resource,dba to coreqi; 

导入语句【log属性可删除】

$imp coreqi/fanqisoft@orcl  file=D:\bak\dmp\coreqi220324.dmp FULL=Y ignore=y log=D:\log\coreqi220324.log

删除用户

drop user coreqi cascade;

删除表空间

drop tablespace coreqi_temp including contents and datafiles CASCADE CONSTRAINTS; 

查询数据库实例信息

select instance from v$thread;