1.第一种,事物级,当 commit以后数据就查不到了。关键字是commit delete rowsCREATE GLOBAL TEMPORARY TABLEt_temp2 ON COMMIT DELETE ROWSAS SELECT 1 AS ID FROM dual;2.第二种,会话级,退出会话以后,数据才查不到关键字comit preserve rowsCREATE GLOBAL TEMPORARY TABLEt_temp1 ON COMMIT PRESERVE ROWSAS S...【阅读全文】
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XPhttp://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.ziphttp://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.ziphttp://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip...【阅读全文】
http://docs.oracle.com/cd/B28359_01/install.111/b32002/pre_install.htm#LADBI2722 Oracle Database Preinstallation RequirementsThis chapter describes the tasks that you must complete before you start Oracle Universal Installer. It includes information about the following tasks:Note...【阅读全文】
今天尝试在Red Hat Linux As5上安装11.2.0.1,因为该版本在as6上安装有一个bug,就是在执行root.sh的时候,报错误.在网上搜了找到了解决办法,于是打算重新安装,重新安装需要将之前安装的完全卸载掉,我这里直接使用oracle提供的deinstall工具还无法删除,估计是我这里是之前安装没有完全成功导致的,于是尝试用了以下的办法删除...【阅读全文】