{"id":352,"date":"2014-05-27T14:13:28","date_gmt":"2014-05-27T06:13:28","guid":{"rendered":"http:\/\/www.wuhaibin.com\/blog\/?p=352"},"modified":"2014-12-03T14:54:36","modified_gmt":"2014-12-03T06:54:36","slug":"oracle-dblink-%e8%ae%bf%e9%97%aelob-%e5%ad%97%e6%ae%b5-ora-22992-%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"http:\/\/www.wuhaibin.com\/blog\/work\/app\/352.html","title":{"rendered":"Oracle DBLink \u8bbf\u95eeLob \u5b57\u6bb5 ORA-22992 \u89e3\u51b3\u65b9\u6cd5"},"content":{"rendered":"

\u5e94\u7528\u80cc\u666f\uff1a<\/h1>\n

\u5728\u5de5\u4f5c\u4e2d\uff0c\u9700\u8981\u5728\u672c\u5730\u6570\u636e\u5e93\u4e2d\u6570\u636e\u94fe\u53e6\u4e00\u4e2a\u6570\u636e\u5e93\u7684\u8868\uff0c\u67e5\u8be2\u5168\u8868\uff0cOracle<\/a><\/span>\u62a5\u9519\u8befORA-22992 \uff0c\u53d1\u73b0\u6570\u636e\u5e93\u94fe\u8868\u4e2d\u6709\u5b57\u6bb5\u683c\u5f0f\u4e3aCLOB\uff0c\u901a\u8fc7\u672c\u6587\u53d1\u73b0\u95ee\u9898\u540e\uff0c\u5728\u67e5\u8be2\u7684\u65f6\u5019\u76f4\u63a5\u67e5\u8be2\u5176\u4ed6\u5b57\u6bb5\uff0c\u907f\u5f00\u6b64\u5b57\u6bb5\uff0c\u76f4\u63a5\u4f7f\u7528\u6570\u636e\u5e93\u94fe\u597d\u4f7f\u3002<\/p>\n

\u8fd9\u7bc7\u6d4b\u8bd5\u4e00\u4e0b\u901a\u8fc7DBLink \u8bbf\u95ee\u542b\u6709Blob\u5b57\u6bb5\u8868\u7684\u65b9\u6cd5\u3002 \u5173\u4e8eDBLINK \u548c Lob \u7684\u8bf4\u660e\uff0c\u53c2\u8003\u5982\u4e0b\u94fe\u63a5\uff1a<\/p>\n

Oracle<\/a><\/span> DBLink<\/p>\n

http:\/\/blog.csdn.net\/tianlesoftware\/article\/details\/4698642<\/p>\n

\u5220\u9664Dblink \u62a5\u9519ORA-02024: database link not found \u7684\u89e3\u51b3\u65b9\u6cd5<\/p>\n

http:\/\/blog.csdn.net\/tianlesoftware\/article\/details\/6160196<\/p>\n

ORACLE LOB \u5927\u5bf9\u8c61\u5904\u7406<\/p>\n

http:\/\/blog.csdn.net\/tianlesoftware\/article\/details\/5070981<\/p>\n

Oracle LOB \u8be6\u89e3<\/p>\n

http:\/\/blog.csdn.net\/tianlesoftware\/article\/details\/6905406<\/p>\n

<\/h1>\n

\u4e00\uff0e\u6a21\u62df\u95ee\u9898<\/h1>\n

1.1\u00a0\u00a0\u5728\u5b9e\u4f8b1\u4e0a\u64cd\u4f5c\uff1a<\/p>\n

\u521b\u5efa\u542b\u6709blob \u7684\u6d4b\u8bd5\u8868\uff1a<\/p>\n

\n
\n
[sql]<\/b>\u00a0view plaincopy\u00a0<\/span><\/div>\n<\/div>\n
    \n
  1. \n
    \/*\u00a0Formatted\u00a0on\u00a02012\/6\/19\u00a010:18:05\u00a0(QP5\u00a0v5.185.11230.41888)\u00a0*\/<\/div>\n<\/li>\n
  2. \n
    CREATE\u00a0TABLE\u00a0lob1<\/div>\n<\/li>\n
  3. \n
    (<\/div>\n<\/li>\n
  4. \n
    \u00a0\u00a0\u00a0line\u00a0\u00a0\u00a0NUMBER\u00a0primary\u00a0key,<\/div>\n<\/li>\n
  5. \n
    \u00a0\u00a0\u00a0text\u00a0\u00a0\u00a0CLOB<\/div>\n<\/li>\n
  6. \n
    );<\/div>\n<\/li>\n
  7. \n
    <\/div>\n<\/li>\n
  8. \n
    INSERT\u00a0INTO\u00a0lob1<\/div>\n<\/li>\n
  9. \n
    \u00a0\u00a0\u00a0SELECT\u00a0distinct\u00a0line,\u00a0text\u00a0FROM\u00a0all_source\u00a0where\u00a0rownum<500;<\/div>\n<\/li>\n
  10. \n
    <\/div>\n<\/li>\n
  11. \n
    SELECT\u00a0segment_name,<\/div>\n<\/li>\n
  12. \n
    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0segment_type,<\/div>\n<\/li>\n
  13. \n
    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0tablespace_name,<\/div>\n<\/li>\n
  14. \n
    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SUM\u00a0(bytes)\u00a0\/\u00a01024\u00a0\/\u00a01024\u00a0||\u00a0'M'\u00a0AS\u00a0\"SIZE\"<\/div>\n<\/li>\n
  15. \n
    \u00a0\u00a0\u00a0\u00a0FROM\u00a0user_segments<\/div>\n<\/li>\n
  16. \n
    \u00a0\u00a0\u00a0WHERE\u00a0segment_name\u00a0=\u00a0'LOB1'<\/div>\n<\/li>\n
  17. \n
    GROUP\u00a0BY\u00a0segment_name,\u00a0segment_type,\u00a0tablespace_name;<\/div>\n<\/li>\n<\/ol>\n<\/div>\n

     <\/p>\n

    LOB \u8868\u7684\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n

    \n
    \n
    [sql]<\/b>\u00a0view plaincopy<\/div>\n<\/div>\n
      \n
    1. SEGMENT_NAME\u00a0\u00a0\u00a0\u00a0SEGMENT_TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TABLESPACE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SIZE<\/li>\n
    2. ---------------\u00a0------------------\u00a0------------------------------\u00a0----------<\/li>\n
    3. LOB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0TABLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09M<\/li>\n
    4. <\/li>\n
    5. SQL>\u00a0set\u00a0wrap\u00a0off;<\/li>\n
    6. SQL>\u00a0select\u00a0*\u00a0from\u00a0lob1\u00a0where\u00a0rownum=1;<\/li>\n
    7. <\/li>\n
    8. \u00a0\u00a0\u00a0LINE\u00a0TEXT<\/li>\n
    9. ----------\u00a0---------------------------------------------------------------------<\/li>\n
    10. \u00a0\u00a0\u00a01\u00a0package\u00a0STANDARD\u00a0AUTHID\u00a0CURRENT_USER\u00a0is\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0--\u00a0care<\/li>\n<\/ol>\n<\/div>\n

       <\/p>\n

      1.2\u00a0\u5728\u5b9e\u4f8b2\u4e0a\u64cd\u4f5c<\/p>\n

      \u521b\u5efaDBLINK\uff1a<\/p>\n

      \n
      \n
      [sql]<\/b>\u00a0view plaincopy<\/div>\n<\/div>\n
        \n
      1. CREATE\u00a0PUBLIC\u00a0DATABASE\u00a0LINK\u00a0lob_link\u00a0CONNECT\u00a0TO\u00a0dave\u00a0IDENTIFIED\u00a0BY\u00a0dave<\/li>\n
      2. USING\u00a0'(DESCRIPTION\u00a0=<\/li>\n
      3. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(ADDRESS_LIST\u00a0=<\/li>\n
      4. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(ADDRESS\u00a0=\u00a0(PROTOCOL\u00a0=\u00a0TCP)(HOST\u00a0=\u00a0192.168.2.222)(PORT\u00a0=\u00a01521))<\/li>\n
      5. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0)<\/li>\n
      6. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(CONNECT_DATA\u00a0=<\/li>\n
      7. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(SERVICE_NAME\u00a0=\u00a0dave)<\/li>\n
      8. \u00a0\u00a0\u00a0\u00a0\u00a0)<\/li>\n
      9. \u00a0\u00a0)';<\/li>\n
      10. <\/li>\n
      11. SQL>\u00a0select\u00a0*\u00a0from\u00a0v$version;<\/li>\n
      12. <\/li>\n
      13. BANNER<\/li>\n
      14. ----------------------------------------------------------------<\/li>\n
      15. Oracle\u00a0Database\u00a010g\u00a0Enterprise\u00a0Edition\u00a0Release\u00a010.2.0.1.0\u00a0-\u00a0Prod<\/li>\n
      16. PL\/SQL\u00a0Release\u00a010.2.0.1.0\u00a0-\u00a0Production<\/li>\n
      17. CORE\u00a0\u00a0\u00a0\u00a010.2.0.1.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Production<\/li>\n
      18. TNS\u00a0for\u00a0Linux:\u00a0Version\u00a010.2.0.1.0\u00a0-\u00a0Production<\/li>\n
      19. NLSRTL\u00a0Version\u00a010.2.0.1.0\u00a0-\u00a0Production<\/li>\n
      20. <\/li>\n
      21. SQL>\u00a0select\u00a0count(*)\u00a0from\u00a0lob1@lob_link;<\/li>\n
      22. \u00a0\u00a0COUNT(*)<\/li>\n
      23. ----------<\/li>\n
      24. \u00a0\u00a0\u00a0\u00a0\u00a058228<\/li>\n<\/ol>\n<\/div>\n

        \u8fd9\u8fb9\u67e5\u8be2\u603b\u8bb0\u5f55\u6570\u6b63\u5e38\u3002\u4f46\u662f\u5f53\u6211\u4eec\u67e5\u8be2\u5177\u4f53LOB\u5b57\u6bb5\u91cc\u7684\u5185\u5bb9\u7684\u65f6\u5019\uff0c\u5c31\u4f1a\u62a5\u9519\uff0c\u5982\u4e0b\uff1a<\/p>\n

         <\/p>\n

        \n
        \n
        [sql]<\/b>\u00a0view plaincopy<\/div>\n<\/div>\n
          \n
        1. SQL>\u00a0select\u00a0*\u00a0from\u00a0lob1@lob_link\u00a0where\u00a0rownum=1;<\/li>\n
        2. ERROR:<\/li>\n
        3. ORA-22992:\u00a0cannot\u00a0use\u00a0LOB\u00a0locators\u00a0selected\u00a0from\u00a0remote\u00a0tables<\/li>\n
        4. <\/li>\n
        5. no\u00a0rows\u00a0selected<\/li>\n
        6. <\/li>\n
        7. [oracle@localhost\u00a0~]$\u00a0oerr\u00a0ora\u00a022992<\/li>\n
        8. 22992,\u00a000000,\u00a0\"cannot\u00a0use\u00a0LOB\u00a0locators\u00a0selected\u00a0from\u00a0remote\u00a0tables\"<\/li>\n
        9. \/\/\u00a0*Cause:\u00a0\u00a0A\u00a0remote\u00a0LOB\u00a0column\u00a0cannot\u00a0be\u00a0referenced.<\/li>\n
        10. \/\/\u00a0*Action:\u00a0\u00a0Remove\u00a0references\u00a0to\u00a0LOBs\u00a0in\u00a0remote\u00a0tables.<\/li>\n<\/ol>\n<\/div>\n

          <\/h1>\n

          \u4e8c\uff0eMOS\u00a0\u4e0a\u7684\u76f8\u5173\u8bf4\u660e<\/h1>\n

          2.1 ORA-22992 When TryingTo Select Lob Columns Over A Database Link [ID 119897.1]<\/p>\n

          \u5728\u5b98\u7f51\u7684\u8fd9\u7bc7\u6587\u7ae0\u4e2d\uff0c\u57fa\u4e8eOracle 8i\u7684\u8fdb\u884c\u4e86\u8bf4\u660e\uff0c\u62a5\u9519\u7684\u539f\u56e0\u662f\u56e0\u4e3a\u4e0d\u652f\u6301\u8fd9\u4e2a\u7279\u6027\u3002<\/p>\n

          (A)You cannot actually select a lob column (i.e. CLOB column) from a table<\/p>\n

          using remote database link.\u00a0 Thisis not a supported feature.<\/p>\n

           <\/p>\n

          (B)Also, these are the INVALID operations on a LOB column:<\/p>\n

          --\u4ee5\u4e0b\u64cd\u4f5c\u4e5f\u4e0d\u88ab\u652f\u6301\u3002<\/p>\n

          1. SELECT lobcol from table1@remote_site;<\/p>\n

          2. INSERT INTO lobtable select type1.lobattr from table1@remote_site;<\/p>\n

          3. SELECT dbms_lob.getlength(lobcol) from table1@remote_site;<\/p>\n

           <\/p>\n

          2.2 ORA-22992 in SQLUsing DBLINK and NVL2 function in 10g. [ID 427239.1]<\/p>\n

          \u5728Oracle 9i\/10g\u7248\u672c\u4e2d\uff0c\u5b58\u5728Bug.5185187\u00a0\uff0c\u56e0\u6b64\u5728dblink\u4e2d\u4f7f\u7528NVL2 \u51fd\u6570\u65f6\uff0c\u5c31\u4f1a\u51fa\u73b0ORA-22992\u7684\u9519\u8bef\u3002<\/p>\n

          \u8be5Bug \u5728Oracle 11gR2\u4e2d\u5df2\u7ecf\u4fee\u590d\u3002<\/p>\n

          \u4e5f\u53ef\u4ee5\u4f7f\u7528\u5982\u4e0b\u65b9\u6cd5\uff0c\u6765\u95f4\u63a5\u7684\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff1a<\/p>\n

          Original SQL:<\/p>\n

          select nvl2('a', 'b','c' )from\u00a0dual@test;<\/p>\n

          Modified SQL:<\/p>\n

          selectto_char(nvl2('a','b','c')) from\u00a0dual@test;<\/p>\n

           <\/p>\n

          2.3 SELECT with a LOB andDBLink Returns an ORA-22992: Cannot Use LOB Locators Selected from Remotetables [ID 1234893.1]<\/p>\n

          \u5728\u8fd9\u8fb9\u6587\u7ae0\u91cc\u4e5f\u63d0\u5230\u4e86\u539f\u56e0\uff1abecause the use ofDBLinks and LOBs via the SELECT from PL\/SQL is not supported.<\/p>\n

          \u5728\u8fd9\u7bc7\u6587\u7ae0\u91cc\u4e5f\u63d0\u4f9b\u4e86\u4e00\u4e9b\u89e3\u51b3\u65b9\u6cd5\uff1a<\/p>\n

          The followingNotes discuss this issue, and give code snippets as example to work-around therestriction using the INTO clause. Keep in mind, if working with large LOBsizes, it may be best to implement the work-around of using a MaterializedView.<\/p>\n

          --\u5982\u679cLOB\u5b57\u6bb5\u5f88\u5927\uff0c\u6700\u597d\u4f7f\u7528\u7269\u5316\u89c6\u56fe\u6765\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u3002<\/p>\n

          Note\u00a0459557.1\u00a0(ORA-1406: FetchedColumn Value was Truncated When Selecting Remote Column into Local BLOBVariable) discusses using a Materialized View in the scenarios where the BLOBwill be larger than 2Meg.<\/p>\n

          Note\u00a0119897.1\u00a0(ORA-22992 When Trying To SelectLob Columns Over A Database Link) states this feature is not supported but thenat the end of the Note it states starting with 10.2 there is a work-around ofusing LONG and LONG RAW types.<\/p>\n

          Note\u00a0436707.1\u00a0(Ora-22992 has a workaround in10gR2) illustrates a work-around (using LONG RAW) as mentioned was possible inthe previous note.<\/p>\n

          Note\u00a0796282.1\u00a0(Workaround for ORA-22992)provides 3 work-arounds.<\/p>\n

           <\/p>\n

          \u4e09\uff0e\u89e3\u51b3\u65b9\u6cd5<\/h1>\n

          3.1\u00a0\u5c06\u63a5\u6536\u7684lob\u00a0\u5b58\u5165char\uff08CBob\uff09\u6216\u8005raw\uff08BLob\uff09\u672c\u5730\u53d8\u91cf<\/p>\n

          MOS\u6587\u7ae0\uff1a<\/p>\n

          Ora-22992 has a workaround in 10gR2 [ID 436707.1]<\/p>\n

          Workaround for ORA-22992 [ID 796282.1]<\/p>\n

          Starting from 10g the \u00a0select from alob object through a\u00a0database link is supportedby\u00a0\u00a0receiving\u00a0the LOB objects into variables defined as CHAR orRAW.<\/p>\n

          --\u4eceOracle10g\u5f00\u59cb\uff0cdblink\u00a0\u7684select\u53ef\u4ee5\u88ab\u672c\u5730\u7684char\u6216raw\u00a0\u7c7b\u578b\u53d8\u91cf\u63a5\u6536\u3002<\/p>\n

          \uff081\uff09\u00a0Selecting a CLOB objectthrough the dblink:<\/p>\n

          set serveroutput on<\/p>\n

          declare
          \nmy_ad varchar(2000);
          \nBEGIN
          \nSELECT obj INTO my_ad FROM test@torem where id=1;
          \ndbms_output.put_line(my_ad);
          \nEND;
          \n\/<\/p>\n

          \u6211\u8fd9\u91cc\u7684\u6d4b\u8bd5\u73af\u5883\u662fCBLOB\uff0c\u793a\u4f8b\u5982\u4e0b\uff1a<\/p>\n

          SQL> declare<\/p>\n

          2\u00a0 my_ad varchar(2000);<\/p>\n

          3\u00a0 BEGIN<\/p>\n

          4\u00a0 SELECT text INTO my_ad FROMlob1@lob_link where rownum=1;<\/p>\n

          5\u00a0 dbms_output.put_line(my_ad);<\/p>\n

          6\u00a0 END;<\/p>\n

          \/<\/p>\n

          7<\/p>\n

          package STANDARD AUTHIDCURRENT_USER is\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -- careful onthis line;<\/p>\n

          SED edit occurs!<\/p>\n

          PL\/SQL procedure successfully completed.<\/p>\n

          --\u8fd9\u91cc\u8f93\u51fa\u4e86\u6211\u4eecCLOB\u91cc\u7684\u5185\u5bb9\u3002<\/p>\n

           <\/p>\n

          \uff082\uff09Selecting a BLOB object through thedblink:<\/p>\n

          declare
          \nmy_ad raw(50);
          \nBEGIN
          \nSELECT obj INTO my_ad FROM test2@torem where id=1;
          \nEND;
          \n\/<\/p>\n

           <\/p>\n

          3.2\u00a0\u4f7f\u7528\u7269\u5316\u89c6\u56fe<\/p>\n

          MOS\u00a0\u6587\u7ae0\uff1a\u00a0ORA-1406: Fetched Column Value was Truncated When Selecting RemoteColumn into Local BLOB Variable [ID 459557.1]<\/p>\n

          \u57283.1 \u4e2d\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528\u672c\u5730\u53d8\u91cf\u6765\u63a5\u6536dblink\u4e2dLOB\u7684\u503c\uff0c\u4f46\u662f\u8fd9\u4e2a\u65b9\u6cd5\u662f\u6709\u9650\u5236\u7684\u3002\u5f53\u6211\u4eec\u63a5\u6536\u7684LOB \u5b57\u6bb5\u503c\u5927\u4e8e32KB\u503c\uff0c\u5c31\u4f1a\u62a5\u5982\u4e0b\u9519\u8bef\uff1a<\/p>\n

          ORA-01406 :fetched column value was truncated<\/p>\n

          \"If the LOBis greater than 32KB - 1 in size, then PL\/SQL will raise a truncation error andthe contents of the buffer are undefined.\"<\/p>\n

          This means thatwe are not able to retrieve BLOBs columns greater than 32KB - 1 in size througha\u00a0database link.<\/p>\n

          The restrictionstill holds good for 11g from Oracledocumention\u00a0 SecureFiles and LargeObjects Developer's Guide<\/p>\n

           <\/p>\n

          3.2.1\u00a0\u6d4b\u8bd5LOB\u5b57\u6bb5\u957f\u5ea6<\/p>\n

          --\u5728\u8fdc\u7a0b\u7aef\u521b\u5efa\u8fc7\u7a0b\uff1a<\/p>\n

          create or replace procedure get_bloblengthas
          \nblob_loc blob;
          \nblob_length number;
          \nbegin
          \nselect <lob_column>
          \ninto blob_loc
          \nfrom\u00a0 <table_name>
          \nwhere name ='<critira>';
          \nblob_length := dbms_lob.getlength(blob_loc);
          \ndbms_output.put_line('Length of the Column : ' || to_char(blob_length));
          \nend;<\/p>\n

          --\u5728\u672c\u5730\u8c03\u7528\u8fc7\u7a0b\uff1a<\/p>\n

          exec get_bloblength@repb<\/p>\n

          \u5982\u679c\u8fd4\u56de\u503c\u5927\u4e8e32KB\uff0c\u6211\u4eec\u5c31\u53ef\u4ee5\u4f7f\u7528\u7269\u5316\u89c6\u56fe\u4e86\u3002<\/p>\n

           <\/p>\n

          3.2.2\u00a0\u521b\u5efa\u7269\u5316\u89c6\u56fe<\/p>\n

          SQL>\u00a0create materializedview lobmv1 as\u00a0select line,text from lob1@lob_link;<\/p>\n

          --\u67e5\u8be2\u7269\u5316\u89c6\u56fe\uff1aCLOB\u6b63\u5e38\u663e\u793a<\/p>\n

          SQL> set wrap off;<\/p>\n

          SQL>\u00a0select * from lobmv where rownum<5;<\/p>\n

          LINE TEXT<\/p>\n

          -------------------------------------------------------------------------------<\/p>\n

          5<\/p>\n

          8\u00a0\u00a0 type NUMBER is NUMBER_BASE;<\/p>\n

          9\u00a0\u00a0 subtype FLOAT is NUMBER; --NUMBER(126)<\/p>\n

          11\u00a0\u00a0 subtype \"DOUBLEPRECISION\" is FLOAT;<\/p>\n

           <\/p>\n

          3.3\u00a0\u5c06\u542b\u6709LOB\u5b57\u6bb5\u7684\u8868\u590d\u5236\u5230\u672c\u5730\u7684\u5168\u5c40\u4e34\u65f6\u8868<\/p>\n

          \u6211\u4eec\u5728\u672c\u5730\u521b\u5efa\u4e00\u5f20\u548cdblink\u8fdc\u7a0b\u7aef\u76f8\u540c\u7684\u5168\u5c40\u4e34\u65f6\u8868\uff0c\u7136\u540e\u5728\u67e5\u8be2\u4e34\u65f6\u8868\uff1a<\/p>\n

          \n
          \n
          [sql]<\/b>\u00a0view plaincopy<\/div>\n<\/div>\n<\/div>\n
            \n
          1. --\u521b\u5efa\u4e34\u65f6\u8868\uff1a<\/li>\n
          2. create\u00a0global\u00a0temporary\u00a0table\u00a0lob2<\/li>\n
          3. (<\/li>\n
          4. \u00a0\u00a0\u00a0line\u00a0\u00a0\u00a0number\u00a0primary\u00a0key,<\/li>\n
          5. \u00a0\u00a0\u00a0text\u00a0\u00a0\u00a0clob<\/li>\n
          6. )<\/li>\n
          7. on\u00a0commit\u00a0delete\u00a0rows;<\/li>\n
          8. <\/li>\n
          9. --\u63d2\u5165\u6570\u636e\uff1a<\/li>\n
          10. SQL>\u00a0insert\u00a0into\u00a0lob2\u00a0select\u00a0line,text\u00a0from\u00a0lob1@lob_link;<\/li>\n
          11. 499\u00a0rows\u00a0created.<\/li>\n
          12. <\/li>\n
          13. SQL>\u00a0select\u00a0*\u00a0from\u00a0lob2\u00a0where\u00a0rownum<5;<\/li>\n
          14. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0LINE\u00a0TEXT<\/li>\n
          15. ----------\u00a0---------------------------------------------------------------------<\/li>\n
          16. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05<\/li>\n
          17. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a08\u00a0\u00a0\u00a0type\u00a0NUMBER\u00a0is\u00a0NUMBER_BASE;<\/li>\n
          18. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09\u00a0\u00a0\u00a0subtype\u00a0FLOAT\u00a0is\u00a0NUMBER;\u00a0--\u00a0NUMBER(126)<\/li>\n
          19. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a011\u00a0\u00a0\u00a0subtype\u00a0\"DOUBLE\u00a0PRECISION\"\u00a0is\u00a0FLOAT;<\/li>\n
          20. <\/li>\n
          21. SQL>\u00a0commit;<\/li>\n
          22. Commit\u00a0complete.<\/li>\n
          23. <\/li>\n
          24. SQL>\u00a0select\u00a0*\u00a0from\u00a0lob2\u00a0where\u00a0rownum<5;<\/li>\n
          25. no\u00a0rows\u00a0selected<\/li>\n
          26. --\u63d0\u4ea4\u4e4b\u540e\u6570\u636e\u5c31\u88ab\u5220\u9664\u4e86\uff0c\u8fd9\u4e2a\u662f\u4e34\u65f6\u8868\u7684\u5c5e\u6027\u3002<\/li>\n<\/ol>\n

            \"oracle\"<\/a><\/p>\n

            \u5e94\u7528\u80cc\u666f\uff1a \u5728\u5de5\u4f5c\u4e2d\uff0c\u9700\u8981\u5728\u672c\u5730\u6570\u636e\u5e93\u4e2d\u6570\u636e\u94fe\u53e6\u4e00\u4e2a\u6570\u636e\u5e93\u7684\u8868\uff0c\u67e5\u8be2\u5168\u8868\uff0cOracle\u62a5\u9519\u8befORA-22992 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[9],"tags":[35],"views":19146,"_links":{"self":[{"href":"http:\/\/www.wuhaibin.com\/blog\/wp-json\/wp\/v2\/posts\/352"}],"collection":[{"href":"http:\/\/www.wuhaibin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.wuhaibin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.wuhaibin.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.wuhaibin.com\/blog\/wp-json\/wp\/v2\/comments?post=352"}],"version-history":[{"count":0,"href":"http:\/\/www.wuhaibin.com\/blog\/wp-json\/wp\/v2\/posts\/352\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.wuhaibin.com\/blog\/wp-json\/wp\/v2\/media?parent=352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.wuhaibin.com\/blog\/wp-json\/wp\/v2\/categories?post=352"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.wuhaibin.com\/blog\/wp-json\/wp\/v2\/tags?post=352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}