- 博客(6)
- 收藏
- 关注
RSS订阅转载 如何查看ORACLE是企业版还是标准版
如何查看ORACLE是企业版还是标准版 SQL> select * from v$version; BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64biPL
2014-04-24 11:00:50
4934
原创 关闭OGG实时异地容灾例子
连接10.218.44.52 关闭异地容灾复制-bash-3.2$ cd /u01/ggs-bash-3.2$ ./ggsciGGSCI (SSORABAK) 2> stop ssrep1Sending STOP request to REPLICAT SSREP1 ...Request processed.GGSCI (SSORABAK) 3> info allP
2014-04-24 10:50:51
623
原创 视图修改的学习
学习视图view ALTER VIEW [schema.]view COMPILE; ALTER VIEW [schema.]view ADD out_of_line_constraint; ALTER VIEW [schema.]view MODIFY CONSTRAINT constraint {RELY | NORELY}; ALTER
2014-04-24 10:34:11
489
原创 一次EXPDP时，CPU上升情况
expdp system/thwz0606sjk directory=DUMP_DIR dumpfile=WL.dmp full=y compression=metadata_only logfile=WL.log : 32959324k total, 32802056k used, 157268k free, 102616k buffersSwap: 4096564k t
2014-04-24 10:26:24
526
转载 关于约束
SELECT F.TABLE_NAME, F.CONSTRAINT_NAME, F.COLUMN_NAME, F.POSITION, P.TABLE_NAME, P.COLUMN_NAME, P.POSITION FROM USER_CONSTRAINTS R, USER_CONS_COLUMNS F, USER_CONS_COLUMNS P WHERE R.OWNER = U
2014-04-24 10:19:41
391
原创 win2003 OGG
创建MGR进程，启动MGR报错。2014-02-18 12:02:16 ERROR OGG-00014 Oracle GoldenGate Manager for ODBC: Unrecognized parameter: INSTALL. Parameter could be misspelled or unsupported.2014-02-18 12:02:16 ERRO
2014-02-19 10:39:44
1305
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人