Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.ADM_COMPARE_LENGTHS
Table FPSADMIN.ADM_COMPARE_LENGTHS"
Stores text length of views, constraints, and PL/SQL source including nonwhitespace length for comparison purposes. The table is needed to convert the text column in ALL_VIEWS from the Oracle long datatype to the clob datatype. Long and clob are both extended length string types and Oracle has weird requirements that the only way to convert is to write to a table. If length_from_all_views is not equal to length_from_text the view likely contains illegal characters
-
Schema: FPSADMIN
-
Tablespace: FPSDATA
-
Primary key: OWNER, OBJECT_NAME, LINE
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
OWNER |
VARCHAR2(30) |
N |
|
|
OBJECT_NAME |
VARCHAR2(30) |
N |
This could be an object name (we will disable loading of that object in the scheduled jobs), a load job (we will disable loading of all objects in that scheduled job), an FPSAPP prefix (we will disable loading of all objects with that prefix), a constraint (we can explain why it is permanently disabled), or a trigger (technically an object so we can get away with omitting this from the column name and also to explain why it is permanently disabled). (* from FPSADMIN.CFG_DISABLED) |
|
LINE |
NUMBER(6) |
N |
|
|
CLOB_TEXT |
CLOB |
N |
|
|
NONWHITESPACE_LENGTH |
NUMBER(9) |