- 博客(7)
- 资源 (2)
- 收藏
- 关注
转载 Oracle 10g logical standby 維護命令
生產環境碰到archive log目錄空間不足,將archive log轉移到新的目錄,需重新註冊archive logalter database register or replace logical logfile '; 網上看到有不錯的logical standby維護命令:http://ningzi82.itpub.net/post/12186/513373Oracle
2012-02-29 14:57:00 783
原创 Oracle 11g can not exp table without rows
SOLUTION:1>alter system set deferred_segment_creation=false scope=both;--can not influence the table before changing this parameter.2>select 'altertable '||table_name||' allocate extent;' from
2012-02-27 11:59:04 488
原创 Oracle TEMPFILE&ONLINE REDO LOG OPERATION
REDO: ALTER DATABASE DROP LOGFILE GROUP XXX;ALTER DATABASE ADD LOGFILE GROUP 1 ('','') SIZE 100M;ALTER SYSTEM SWITCH LOGFILE;SELECT GROUP#,THREAD#,MEMEBERS,STATUS FROM V$LOG; TEMPFILE:AL
2012-02-08 15:35:26 652
原创 Oracle Patchset Number
Patchset / PSU Patch Number 11.2.0.3 1040453011.2.0.2.4 1282772611.2.0.2.3 1241933111.2.0.2.2 1172491611.2.0.2.1 1024852311.
2012-02-03 08:30:23 555
原创 ICS-Internet Connection Sharing
Internet Connection Sharing (ICS) is the use of a device with Internet access such as 3G cellular service, broadband via Ethernet, or other Internet gateway as an access point for other devices. It wa
2012-02-02 18:09:38 716
原创 Oracle 使用其他用户sequence
GRANT SELECT ON SEQ_NAME TO XXX;REVOKE SELECT ON SEQ_NAME FROM XXX;
2012-02-02 16:12:16 3290
原创 Oracle 11g New Features-密码过期&密码区分大小写
SELECT * FROM dba_profiles WHERE PROFILE = 'DEFAULT' AND resource_name = 'PASSWORD_LIFE_TIME';ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;SELECT * FROM dba_profiles WHERE PR
2012-02-02 09:58:12 539
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人