小小彭

create or replace procedure URP_USER1 isv_err varchar2(512); --错误代码CURSOR user1 is select t.* from URP_DEPT1 t where t.yydz is null;URP_USER1 user1%rowtype;begin open user1; loop FETCH user1 INTO URP_USER...

1.查看进程ps -ef|grep websphere2.进路径cd /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/bin3.重启服务器./stopServer.sh server1;./starServer.sh server1;1.查看oracle安装路径目录select file_name,tablespace_name,bytes/1024/1024 "bytes MB",maxbytws/1024/1024...

–查找工作空间的路径select * from dba_data_files;–删除表空间drop tablespace 表空间名称 including contents and datafiles cascade constraint;

检测本电脑是否安装Oracle 还能检查版本sqlplus / as sysdba 以最高权限进去忘记oracle数据库账号密码一：以最高管理员的权限进去sqlplus / as sysdba二：在 sql 里面输入要修改的账号和密码alter user system identified by system;alter user scoot identified by scoot;三：然后你就可以连接自己的数据库了...

https://www.oracle.com/database/technologies/oracle-database-software-downloads.html