ALTER CATALOG
ALTER [CATALOG|CATALOGUE] ADD TABLE 'tablename' [FOR UPDATE]
This statement allows an existing Oracle table to be brought into the catalog allowing KI_OPEN to open it. KCML will inspect the existing columns and attempt to map them to KDB supported datatypes. Partitioned tables are NOT supported.
If the optional FOR UPDATE clause is added then KCML will ensure the required private lock and RCN columns exist.
Existing regular indexes that follow the naming convention used in CREATE INDEX will be imported. Word indexes are not imported nor are sequences implementing an auto-incrementing column.
To reverse this statement, that is to drop an entry from the catalog without affecting the Oracle table, use DROP TABLE with the FROM CATALOG clause.