关小真

select 'drop table '||table_name||';' from user_tables ;select 'drop view '||view_name||';' from user_views ;select 'drop sequence '||sequence_name||';' from user_sequences ;select 'drop procedur

使用具有 DBA 权限的 Linux 用户登陆 Oracle 服务器sqlplus / as sysdbacreate user {userName} identified by {password} default tablespace {tablespaceName} temporary tablespace {temporaryName} profile DEFAULT;