创建并删除表空间Oracle [英] CREATE and DROP TABLESPACE Oracle

问题描述

我已经创建了这个表空间

I have created this tablespace

CREATE TABLESPACE IA643_TBS
DATAFILE 'IA643_dat' SIZE 500K
AUTOEXTEND ON NEXT 300K MAXSIZE 100M;

我尝试使用此命令将其删除

I tried to drop it using this command

DROP TABLESPACE IA643_TBS;

它说它已被删除，当我再次尝试创建它时，我收到了以下错误消息:

And it said that it was dropped, when I tried to create it again, I got those error messages:

ERROR at line 1: 
ORA-01119: error in creating database file 'IA643_dat' 
ORA-27038: created file already exists 
OSD-04010: <create> option specified, file already exists 

如何删除数据文件并使用相同的文件名重新创建表空间?

How can I delete the datafile and recreate the tablespace with same file names?

推荐答案

您可以登录操作系统并实际删除文件，也可以在create tablespace命令中的大小后添加reuse关键字.

You can either login to the operating system and actually delete the file or add the reuse keyword after the size in your create tablespace command.

这篇关于创建并删除表空间Oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！