创建临时表空间:
1 create temporary tablespace coreqi_temp 2 tempfile 'D:\oracle\data\coreqi_temp.dbf' 3 size 50m 4 autoextend on 5 next 50m maxsize 20480m 6 extent management local;
创建数据表空间:
1 create tablespace coreqi_data 2 datafile 'D:\oracle\data\coreqi_data.dbf' 3 size 50m 4 autoextend on 5 next 50m maxsize 20480m 6 extent management local;
创建用户并指定默认表空间和临时表空间
1 create user coreqi identified by 1 default tablespace coreqi_data temporary tablespace coreqi_temp;
授权新用户
1 Grant connect,resource,dba to coreqi;
导入语句【log属性可删除】
1 $imp coreqi/fanqisoft@orcl file=D:\bak\dmp\coreqi220324.dmp FULL=Y ignore=y log=D:\log\coreqi220324.log
删除用户
1 drop user coreqi cascade;
删除表空间
1 drop tablespace coreqi_temp including contents and datafiles CASCADE CONSTRAINTS;
查询数据库实例信息
1 select instance from v$thread;