两种删除用户语句的区别

usernickliu

10046 truning 牛

usernickliu

原帖由 Kamus 于 2010-4-18 22:45 发表
根据trace文件，在drop user xxxx cascade以后，oracle在后台要删除下面这么多表里面的相关记录，最后一步才DELETE FROM USER$ ，这就是区别。。。

DELETE FROM DBMS_PARALLEL_EXECUTE_TASK$
delete from system.aq$_internet_agent_privs
delete from sys.streams$_propagation_process
DELETE FROM DR$INDEX_SET_INDEX
DELETE FROM DR$INDEX_SET
DELETE FROM DR$SQE
DELETE FROM SYS.JOB$
DELETE FROM REGISTRY$
DELETE FROM REGISTRY$SCHEMAS
DELETE FROM SYSTEM.REPCAT$_TEMPLATE_SITES
DELETE FROM SYSTEM.REPCAT$_REPCATLOG
DELETE FROM SYSTEM.REPCAT$_REPOBJECT
DELETE FROM SYSTEM.REPCAT$_GROUPED_COLUMN
DELETE FROM SYSTEM.REPCAT$_COLUMN_GROUP
DELETE FROM SYSTEM.REPCAT$_AUDIT_COLUMN
DELETE FROM SYSTEM.REPCAT$_PARAMETER_COLUMN
DELETE FROM SYSTEM.REPCAT$_RESOLUTION
DELETE FROM SYSTEM.REPCAT$_CONFLICT
DELETE FROM SYSTEM.REPCAT$_REPCAT
DELETE FROM SYS.SLOG$
DELETE FROM SYS.MLOG$
DELETE FROM SYS.SNAP$
DELETE FROM SYS.REG_SNAP$
DELETE FROM SYS.SNAP_COLMAP$
DELETE FROM SYS.SNAP_REFOP$
DELETE FROM SYS.SNAP_REFTIME$
DELETE FROM SYS.MLOG_REFCOL$
DELETE FROM SYS.SNAP_OBJCOL$
DELETE FROM RGCHILD$
DELETE FROM RGCHILD$
DELETE FROM RGROUP$
delete from sys.audit$
delete from xdb.xdb$xidx_param_t
delete from sysauth$
delete from proxy_info$
delete from proxy_role_info$
delete from defrole$
delete from user_history$
DELETE FROM LBACSYS.LBAC$USER
delete from user$

能具体说一下是如何操作的吗？
请把具体的操作写出来看看？

xsmdel

没仔细看哈。人家是通过生成trace文件里的记录进行判断。

usernickliu

仔细看了，我的意思，如何来truning drop user test