Current defn of column in table NOTIFICATION
DETAIL VARCHAR2(4000),
Want it to be a CLOB.
create a temporary table 'NOTIFICATION2' with the required column defintions. This is then used as a template to convert the table column.
exec dbms_redefinition.start_redef_table('TSUSER','NOTIFICATION','NOTIFICATION2','ID, RECIPIENT, SUBJECT, TO_CLOB(DETAIL) DETAIL, FOOTER, ISSUE_DATE, SENT_DATE, SENT_STATUS, RETRY_COUNT, ROLE',dbms_redefinition.cons_use_pk);
exec dbms_redefinition.finish_redef_table('TSUSER','NOTIFICATION','NOTIFICATION2');
Tuesday, 27 April 2010
Subscribe to:
Post Comments (Atom)
Blog Archive
-
►
2009
(14)
-
►
October
(7)
- Becoming really rich with Scala
- Checking how to use blogger for side by side code ...
- Scala, lazy evaluation and the Sieve of Eratosthen...
- Scala Streams for iteration / Use streams to avoid...
- Scala: C style iterate function for building lists...
- C style for loops in Scala with break and continue...
- Using syntax version of SyntaxHighlighter with Blo...
-
►
October
(7)
4 comments:
先告訴自己希望成為什麼樣的人,然後一步一步實踐必要的步驟。........................................
三更燈火五更雞,正是男兒讀書時 ..................................................
自慰自拍成人全裸打炮打手槍打飛機巨乳巨奶女優大奶性交性愛淫蕩淫慾淫亂淫婦淫妹淫叫淫水淫女情慾情色做愛限制級波霸口交18禁貼圖寫真視訊援交露點爆乳
A good medicine tastes bitter. .............................................
Post a Comment