Pages

▼

Saturday, July 29, 2006

PeopleSoft and LONG datatype

Somebody knows when PeopleSoft will stop to use LONG datatype, even into the very last version, there is too much these ones :
SQL> select count(distinct table_name)
    from user_tab_columns
    where data_type = 'LONG'
SQL> /

COUNT(DISTINCTTABLE_NAME)
-------------------------
2085

SQL>
à l'adresse

4 comments:

  1. Laurent SchneiderJuly 31, 2006 10:30 AM

    I wonder when oracle is going to make DBA_VIEWS.TEXT, DBA_SOURCE.TEXT, DBA_CONSTRAINTS.SEARCH_CONDITION clobs...

    it such a pain to search in long

    ReplyDelete
  2. Nicolas GasparottoJuly 31, 2006 10:50 AM

    Yeah, I have to say that we always must find some workaround whenever we munipulate these applicative tables... Well, wait and see. -:(

    ReplyDelete
  3. Jaouad ZOUAGHIFebruary 15, 2007 1:54 PM

    hi Nicolas ,

    it' possible to become a problem when we do a database reoragnisation with move and rebuild Indexes. Table with Long columns need and import - Export ( Or datapump with 10G version )

    ReplyDelete
  4. Nicolas GasparottoFebruary 15, 2007 5:01 PM

    Hi Jaouad,
    Yes, that's one of the case why it would great that Peoplesoft does no more use LONG datatype.

    ReplyDelete