SQL> select count(distinct table_name)
from user_tab_columns
where data_type = 'LONG'
SQL> /
COUNT(DISTINCTTABLE_NAME)
-------------------------
2085
SQL>
Multilevel Drop Zones
2 days ago
Oracle & PeopleSoft administration tasks
SQL> select count(distinct table_name)
from user_tab_columns
where data_type = 'LONG'
SQL> /
COUNT(DISTINCTTABLE_NAME)
-------------------------
2085
SQL>
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