Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Wednesday, October 3, 2007

Who uses the OBT_AA schema in Apps

OBT_AA is used by ILM product. Only objects inside this schema are db links, functions, packages, procedures and synonyms. No tables in this one.

SQL> SELECT DISTINCT OBJECT_TYPE
2 FROM DBA_OBJECTS
3 WHERE OWNER='OBT_AA';

OBJECT_TYPE
-------------------
DATABASE LINK
FUNCTION
PACKAGE
PACKAGE BODY
PROCEDURE
SYNONYM
VIEW

No comments: