Changes to OLCI tables

You will need to update the following items when making changes to OLCI.
See sample script.

-- CHECKIN_PASSENGER TABLE
ALTER TABLE WEB_OWNER.CHECKIN_PASSENGER

-- CHECKIN_PASSENGER_DELETED TABLE
ALTER TABLE WEB_OWNER.CHECKIN_PASSENGER_DELETED

-- CHECKIN_PASSENGER_ARC TABLE
ALTER TABLEĀ  WEB_ARCHIVE.CHECKIN_PASSENGER_ARC

-- CHECKIN_PASSENGER_DELETED_ARC TABLE
ALTER TABLE WEB_ARCHIVE.CHECKIN_PASSENGER_DELETED_ARC

-- CHECKIN_DELETE_TRG TRIGGER
TRIGGER "WEB_OWNER"."CHECKIN_DELETE_TRG"
ALTER TRIGGER "WEB_OWNER"."CHECKIN_DELETE_TRG" ENABLE;

-- CHECKIN_ARCHIVE_PROCESS
PACKAGE BODY CHECKIN_ARCHIVE_PROCESS is

Leave a Reply