Designer Repository Scripts

List Developer Repository Owners

select distinct owner from sys.dba_segments where segment_name = ‘SDD_ELEMENTS’; REM D2K user privs: REM REM Run this from your PC as SYS to create role des2000_owner REM @c:\repadm20\utl\ckrorole.sql REM grant des2000_owner to &&repos_owner; REM REM grant execute on dbms_lock to &&repos_owner; REM grant execute on dbms_pipe to &&repos_owner; REM grant select on dba_rollback_segs to &&repos_owner;…

List column descriptions per table

break on TAB on COL col tab format a30 trunc col col format a30 trunc SELECT AL2.NAME TAB, AL3.NAME COL, AL4.TXT_TEXT FROM CI_APPLICATION_SYSTEMS AL1, CI_TABLE_DEFINITIONS AL2, CI_COLUMNS AL3, CDI_TEXT AL4, SDD_ELEMENTS AL5 WHERE AL1.NAME = ‘FRANK’ — Enter your app name here !!! AND AL1.LATEST_VERSION_FLAG = ‘Y’ AND AL1.ID = AL2.APPLICATION_SYSTEM_OWNED_BY AND AL2.ID = AL3.TABLE_REFERENCE…

List table primary and foreign key references

break on TAB col tab format a15 col col format a15 col fk_tab format a15 col fk_col format a15 SELECT AL2.NAME TAB, AL3.NAME COL, AL4.CONSTRAINT_TYPE, DECODE(AL7.EL_NAME,’.’,’ ‘,AL7.EL_NAME) FK_TAB, DECODE(AL5.EL_NAME,’.’,’ ‘,AL5.EL_NAME) FK_COL FROM CI_APPLICATION_SYSTEMS AL1, CI_TABLE_DEFINITIONS AL2, CI_COLUMNS AL3, CI_KEY_COMPONENTS AL4, SDD_ELEMENTS AL5, SDD_ELEMENTS AL6, SDD_ELEMENTS AL7 WHERE (AL4.CONSTRAINT_REFERENCE=AL6.EL_ID(+) AND AL5.EL_WITHIN_ID = AL7.EL_ID(+) AND AL4.FOREIGN_COLUMN_REFERENCE =…

List Developer/2000 Applications

col application format a30 col version format 999 col title format a40 trunc select NAME APPLICATION, VERSION, DISPLAY_TITLE TITLE from CI_APPLICATION_SYSTEMS WHERE LATEST_VERSION_FLAG = ‘Y’ ORDER BY NAME, VERSION DESC /