SQL> select count(distinct table_name)
from user_tab_columns
where data_type = 'LONG'
SQL> /
COUNT(DISTINCTTABLE_NAME)
-------------------------
2085
SQL>
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 :
Subscribe to:
Post Comments (Atom)
4 comments:
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
Yeah, I have to say that we always must find some workaround whenever we munipulate these applicative tables... Well, wait and see. -:(
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 )
Hi Jaouad,
Yes, that's one of the case why it would great that Peoplesoft does no more use LONG datatype.
Post a Comment