2014年3月12日

insert into varchar2(8000)

摘要： 在看12c的文档的时候发现varcahr2最大长度是4000 byteVARCHAR2 Data TypeTheVARCHAR2data type specifies a variable-length character string. When you create aVARCHAR2column, you supply the maximum number of bytes or characters of data that it can hold. Oracle subsequently stores each value in the column exactly as you s 阅读全文

posted @ 2014-03-12 17:53 kramer 阅读(669) 评论(0) 推荐(0) 编辑

dataguard switchover to physical stnadby

摘要： 首先做一系列的checkcheck 当前primary 的 standby redo log是否存在SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_---------- ------- ------- ------------------------------------------------------- --- 3 ONLINE /oracle_asm/standby/it... 阅读全文

posted @ 2014-03-12 15:03 kramer 阅读(328) 评论(0) 推荐(0) 编辑

导航