declare flag integer default 0;
begin
select 1 into flag from v$tablespace a
where a.NAME = 'tarena_data ';
execute immediate 'drop tablespace tarena_data including contents and datafiles';
exception when no_data_found then
execute immediate 'create tablespace tarena_data logging
datafile 'E:/tarena_data01 .dbf'
size 32M
autoextend on
next 32M maxsize 1024M
extent management local';
end;
execute immediate 'drop tablespace tarena_data including contents and datafiles';
这句话怎么运行不了呢?
begin
select 1 into flag from v$tablespace a
where a.NAME = 'tarena_data ';
execute immediate 'drop tablespace tarena_data including contents and datafiles';
exception when no_data_found then
execute immediate 'create tablespace tarena_data logging
datafile 'E:/tarena_data01 .dbf'
size 32M
autoextend on
next 32M maxsize 1024M
extent management local';
end;
execute immediate 'drop tablespace tarena_data including contents and datafiles';
这句话怎么运行不了呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货