oracle的错误的用户下建了表、序列、存储过程

脑子不清楚没有看清操作说明就随便的运行了oracle建库脚本。

oracle的错误的在管理员SYS用户下建了表、序列、存储过程。删除的办法。

Select 'Drop Table ' ||TABLE_NAME||';' From User_Tables
Where TABLE_NAME Like 'T\_%'
Escape '\'

Select * From user_procedures
Where procedure_name Like 'FN\_%' Or  procedure_name Like 'P\_%'
Escape '\'

Select 'DROP PROCEDURE '|| Name ||';' From (
Select Distinct Name  From USER_SOURCE
Where  Name Like 'P\_%'
Escape '\'
)

Or  Name Like 'P\_%'

Select 'DROP SEQUENCE '||SEQUENCE_NAME||';' From USER_SEQUENCES
Where SEQUENCE_NAME Like 'SEQ_%'
Escape '\'