Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\sql\afsvcfkc.sql
REM $Header: afsvcfkc.sql 26.0 2002/11/27 03:00:39 sacsharm ship $ REM *********************************************************************** REM NAME REM afsvcfkc.sql - GSC Primary,Unique and Foreign Key constraint Create REM DESCRIPTION REM Adds constraints to all GSC tables REM USAGE REM sqlplus apps/apps @afsvcfkc applsys fnd REM ******************************************************************** REM Connect to base account REM (autopatch will run all scripts in apps account) connect &1/&2; REM Continue in case of error where constraints aready exist WHENEVER SQLERROR CONTINUE; -- M:\sacsharm\wfsvc.con -- -- Generated for Oracle 8.1 on Tue Nov 19 12:59:13 2002 by Server Generator 6.5.82.2.0 -- Manually Added PROMPT Creating Primary Key on 'FND_SVC_COMP_PARAM_VALS' ALTER TABLE FND_SVC_COMP_PARAM_VALS ADD (CONSTRAINT FND_SVC_COMP_PARAM_VALS_PK1 PRIMARY KEY (COMPONENT_PARAMETER_ID)) / -- Manually Added PROMPT Creating Primary Key on 'FND_SVC_COMP_REQUESTS' ALTER TABLE FND_SVC_COMP_REQUESTS ADD (CONSTRAINT FND_SVC_COMP_REQUESTS_PK1 PRIMARY KEY (COMPONENT_REQUEST_ID)) / PROMPT Creating Primary Key on 'FND_SVC_COMPONENTS' ALTER TABLE FND_SVC_COMPONENTS ADD (CONSTRAINT FND_SVC_COMPONENTS_PK1 PRIMARY KEY (COMPONENT_ID)) / PROMPT Creating Primary Key on 'FND_SVC_COMP_PARAMS_TL' ALTER TABLE FND_SVC_COMP_PARAMS_TL ADD (CONSTRAINT FND_SVC_COMP_PARAMS_TL_PK1 PRIMARY KEY (PARAMETER_ID ,LANGUAGE)) / PROMPT Creating Primary Key on 'FND_SVC_COMP_TYPES_B' ALTER TABLE FND_SVC_COMP_TYPES_B ADD (CONSTRAINT FND_SVC_COMP_TYPES_B_PK1 PRIMARY KEY (COMPONENT_TYPE)) / PROMPT Creating Primary Key on 'FND_SVC_COMP_TYPES_TL' ALTER TABLE FND_SVC_COMP_TYPES_TL ADD (CONSTRAINT FND_SVC_COMP_TYPES_TL_PK1 PRIMARY KEY (COMPONENT_TYPE ,LANGUAGE)) / PROMPT Creating Primary Key on 'FND_SVC_COMP_REQUESTS_H' ALTER TABLE FND_SVC_COMP_REQUESTS_H ADD (CONSTRAINT FND_SVC_COMP_REQUESTS_H_PK1 PRIMARY KEY (REQUEST_HISTORY_ID)) / PROMPT Creating Primary Key on 'FND_SVC_COMP_PARAMS_B' ALTER TABLE FND_SVC_COMP_PARAMS_B ADD (CONSTRAINT FND_SVC_COMP_PARAMS_B_PK1 PRIMARY KEY (PARAMETER_ID)) / /************* No FKs are created, only indexes are defined ****** PROMPT Creating Foreign Key on 'FND_SVC_COMPONENTS' ALTER TABLE FND_SVC_COMPONENTS ADD (CONSTRAINT FND_SVC_COMPONENTS_FK1 FOREIGN KEY (COMPONENT_TYPE) REFERENCES FND_SVC_COMP_TYPES_B (COMPONENT_TYPE)) / PROMPT Creating Foreign Key on 'FND_SVC_COMP_PARAMS_TL' ALTER TABLE FND_SVC_COMP_PARAMS_TL ADD (CONSTRAINT FND_SVC_COMP_PARAMS_TL_FK1 FOREIGN KEY (PARAMETER_ID) REFERENCES FND_SVC_COMP_PARAMS_B (PARAMETER_ID)) / PROMPT Creating Foreign Key on 'FND_SVC_COMP_TYPES_TL' ALTER TABLE FND_SVC_COMP_TYPES_TL ADD (CONSTRAINT FND_SVC_COMP_TYPES_TL_FK1 FOREIGN KEY (COMPONENT_TYPE) REFERENCES FND_SVC_COMP_TYPES_B (COMPONENT_TYPE)) / PROMPT Creating Foreign Key on 'FND_SVC_COMP_PARAMS_B' ALTER TABLE FND_SVC_COMP_PARAMS_B ADD (CONSTRAINT FND_SVC_COMP_PARAMS_B_FK1 FOREIGN KEY (COMPONENT_TYPE) REFERENCES FND_SVC_COMP_TYPES_B (COMPONENT_TYPE)) / *************************************************/ commit; exit;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de