1 Reply Latest reply: Nov 11, 2004 8:42 AM by 358102 RSS

    moving a table with long data type column

    409632
      hi
      1.how to move a table with a long data type column in 8.1.7.3.0 ver database.

      alter table APPLSYS.FND_LOBS_DOCUMENT move lob(BLOB_CONTENT) store as (tablespace testing)
      *
      ERROR at line 1:
      ORA-00997: illegal use of LONG datatype

      2. and a table with varray type column

      alter table APPLSYS.WF_ERROR move lob("USER_DATA"."PARAMETER_LIST") store as (tablespace testing)
      *
      ERROR at line 1:
      ORA-22917: use VARRAY to define the storage clause for this column or attribute

      table description is:

      SQL> desc applsys.wf_error;
      Name Null? Type
      ----------------------------------------- -------- ---------------
      Q_NAME VARCHAR2(30)
      MSGID NOT NULL RAW(16)
      CORRID VARCHAR2(128)
      PRIORITY NUMBER
      STATE NUMBER
      DELAY DATE
      EXPIRATION NUMBER
      TIME_MANAGER_INFO DATE
      LOCAL_ORDER_NO NUMBER
      CHAIN_NO NUMBER
      CSCN NUMBER
      DSCN NUMBER
      ENQ_TIME DATE
      ENQ_UID NUMBER
      ENQ_TID VARCHAR2(30)
      DEQ_TIME DATE
      DEQ_UID NUMBER
      DEQ_TID VARCHAR2(30)
      RETRY_COUNT NUMBER
      EXCEPTION_QSCHEMA VARCHAR2(30)
      EXCEPTION_QUEUE VARCHAR2(30)
      STEP_NO NUMBER
      RECIPIENT_KEY NUMBER
      DEQUEUE_MSGID RAW(16)
      SENDER_NAME VARCHAR2(30)
      SENDER_ADDRESS VARCHAR2(1024)
      SENDER_PROTOCOL NUMBER
      USER_DATA APPS.WF_EVENT_T

      lob column:

      SQL> select owner,table_name,column_name from dba_lobs where table_name='WF_ERROR';

      OWNER TABLE_NAME COLUMN_NAME
      ---------------------------------------------------------
      APPLSYS WF_ERROR "USER_DATA"."PARAMETER_LIST"

      APPLSYS WF_ERROR "USER_DATA"."EVENT_DATA"

      pls help me

      thanks and regards
      srinivas