Undo Tablespace
After atransaction is committed, undo data is no longer needed for rollback ortransaction recovery purposes. However, for consistent read purposes,long-running queries may require this ol...
Linux的基本网络配置
一、 IP立即更改:#ifconfig eth0 <ip地址> netmask <子网掩码> 永久更改: 编辑/etc/sysconfig/network-scripts/ifcfg-eth0 配置网卡的地址 IPADDR=XXX.XXX.XXX.XXX [root@redhat network-scripts]# cat ifcfg-eth0D...
ORA-00201
SQL> alter database mount;alter database mount*ERROR at line 1:ORA-00201: controlfile version 10.1.0.2.0 incompatible with ORACLE version10.0.0.0.0ORA-00202: controlfile: 'E:ORACLEPRODUCT10.1.0ORADATA...
在AIX 上安装DB2 碰到的错误
这两天因为工作需要,搭建DB2 9.1 For AIX 5.3, DB2 8.1 For AIX 5.2环境。总的来讲还算顺利,不过也碰到不少问题,共享一下经验。 1。获取安...
ORA-25153: Temporary Tablespace is Empty
ORA-25153: Temporary Tablespace is Empty 想起前几天重建了控制文件,才导致tempfile丢失,重新把tempfile加进去就可以了SYS>select * from v$tempfile;no rows selectedSYS>alter tablespace temp2 add tempfile ...