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

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;

 

posted @ 2023-12-21 15:10  梧桐潇雨  阅读(396)  评论(0)    收藏  举报