自己做个批处理,在SYSDBA用户下执行大概语句如下:select object_name,object_type
into is_name,is_type
from all_object where owner ='user_name';execute immediate 'drop '||is_type||' '||is_name ;
into is_name,is_type
from all_object where owner ='user_name';execute immediate 'drop '||is_type||' '||is_name ;
spool drop.sql
select 'drop '||object_type||' '||object_name||';' from user_objects;
spool off;
@drop.sql;
commit;
drop user user01 cascade;
请给我写一个好吗
spool drop.sql
select 'drop '||object_type||' '||object_name||';' from user_objects;
spool off;
@drop.sql;
commit;这段可以给我详细讲解一下吗?谢谢
select 'drop '||object_type||' '||object_name||';' from user_objects;
spool off;
@drop.sql;
commit;这个就是一个完整的批处理了:)
drop user user01 cascade;
CREATE USER user01 IDENTIFIED BY "******";
grant connect,resource,imp_full_database,exp_full_database,
create public synonym,drop public synonym to user01 ;
select 'drop '||object_type||' '||object_name||';' from user_objects;
spool off;
@drop.sql;
commit;
我在sqlplus环境下运行这个问题啊.可我也不知道每句的具体意思.请说明以下可以吗
select 'drop '||object_type||' '||object_name||';' from user_objects;
spool off;上面三句 将查询结果写入到drop.sql这个文件,查询结果类似drop table a;drop index b等等
@drop.sql; 执行drop.sql文件里的内容
commit;提交事务