SQL> Drop tablespace tablespace_name INCLUDING CONTENTS ;
有什么办法可以查询到表空间中有那些对象?----------------------------------------------- SQL>select * from dba_objects SQL>where tablespace_name='TABLESPACE_NAME'
to zgh2003(世纪飞扬): 执行Drop tablespace tablespace_name INCLUDING CONTENTS ; 提示和在DBA Studio中一样。dba_objects中没有tablespace_name字段,执行select * from dba_objects where owner = username 可以查到该user的对象还存在,而用户已经被删除了。如何才能将此表空间删除?
declare cursor t_sor is select object_name,OBJECT_TYPE from dba_objects where OWNER='当前用户'; str varchar2(100); begin for v_sor in t_sor loop str:='drop '||v_sor.OBJECT_TYPE||' '||v_sor.object_name||'CASCADE CONSTRAINTS '; execute immediate str; end loop; end; /
SQL>select * from dba_objects
SQL>where tablespace_name='TABLESPACE_NAME'
提示和在DBA Studio中一样。dba_objects中没有tablespace_name字段,执行select * from dba_objects where owner = username 可以查到该user的对象还存在,而用户已经被删除了。如何才能将此表空间删除?
cursor t_sor is
select object_name,OBJECT_TYPE from dba_objects where OWNER='当前用户';
str varchar2(100);
begin
for v_sor in t_sor loop
str:='drop '||v_sor.OBJECT_TYPE||' '||v_sor.object_name||'CASCADE CONSTRAINTS ';
execute immediate str;
end loop;
end;
/