select * from dba_directories;
sqlplus sys/oracle as sysdba
shutdown immediate;
startup;
startup force;
快速输入drop user C##DFECMESDEV cascade;
sqlplus sys/oracle as sysdba
创建目录
create or replace directory expdp_dir as 'D:\expdp_dir';
创建表空间
create tablespace dfecmes datafile 'D:\expdp_dir\dfecmes.dmp' size 100m autoextend on next 10m;
删除表空间
drop tablespace dfecmes20 including contents and datafiles;
select 'alter table '||owner||'.'||table_name||' drop constraint '||constraint_name||' ;'
from dba_constraints
where constraint_type in ('U', 'P')
and (index_owner, index_name) in
(select owner, segment_name
from dba_segments
where tablespace_name = upper('hengtong'));
alter database datafile 'd:\XXX.DBF' offline drop;
alter database open;
创建用户htgd,命令为
create user C##DFECMESDEV identified by DFECMESDEV default tablespace DFECMESDEV;
授权sit,命令为
grant dba,resource,connect to C##DFECMESDEV;
读写权限授予用户
grant read,write on directory DATA_PUMP_DIR to C##DFECMESDEV;