526互联

ORA-27038: 所创建的文件已存在

发布时间 2023-12-21 15:14:53作者: 梧桐潇雨

1、重新建立表空间  存储文件  用户联系

create tablespace DB_PKI datafile 'DB_PKI_TABLESPACE.dbf' size 200M reuse autoextend on next 5M maxsize unlimited;
create user DB_PKI IDENTIFIED BY "123456" default tablespace DB_PKI temporary tablespace TEMP profile DEFAULT;
grant connect,resource,create session,create table,unlimited tablespace to DB_PKI;

2、删除用户 表空间 及存储文件

drop user PANDORA_ADMIN cascade;
drop tablespace PANDORA_ADMIN including contents and datafiles cascade constraint;