TIPTOP ERP 删除tiptop库资料

  删除tiptop库资料

<script type="text/javascript"> document.body.oncopy = function() { if (window.clipboardData) { setTimeout(function() { var text = clipboardData.getData("text"); if (text && text.length>300) { text = text + "/r/n/n本文来自优快云博客，转载请标明出处：" + location.href; clipboardData.setData("text", text); } }, 100); } } </script> <script type="text/javascript">function StorePage(){d=document;t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://www.365key.com/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=475,height=575,left=75,top=20,status=no,resizable=yes'));keyit.focus();}</script>

例：删除ds60

1: 使用管理员登录：sqlplus system/****** @topprod

2: 登录以后就可以drop了：drop user ds60 cascade;

3: 一般就可以了。提示“ORA-01940: cannot drop a user that is currently connected”时需查找并删除连接到ds60的用户

4: 使用sql语句查询连接用户：select username,sid,serial#,status from v$session;

5: 使用sql语句删除连接用户：alter system kill session sid,serial#; （sid,serial#为你要删除的用户）

6: 在drop就可以了：drop user ds60 cascade;