DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_DATABASE_SERVICES

Object Details
Object Name: FND_DATABASE_SERVICES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_DATABASE_SERVICES
Subobject Name:
Status: VALID


The FND_DATABASE_SERVICES table tracks the named database services.
This information will be used in init.ora, and tnsnames.ora generation.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_DATABASE_SERVICES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDB_SERVICE_GUID
FND_DATABASE_SERVICES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDB_GUID
ColumnSERVICE_NAME
Columns
Name Datatype Length Mandatory Comments
DB_SERVICE_GUID RAW (16) Yes Unique idendifier. Needed, since service names typically are named after the database, and may need to change upon cloning
DB_GUID RAW (16) Yes Foreign key to FND_DATABASES
SERVICE_NAME VARCHAR2 (255) Yes Service_Name
DESCRIPTION VARCHAR2 (2000)
Optional description set by user
CREATED_BY NUMBER
Yes Standard "who" column
CREATION_DATE DATE
Yes Standard "who" column
LAST_UPDATED_BY NUMBER
Yes Standard "who" column
LAST_UPDATE_DATE DATE
Yes Standard "who" column
LAST_UPDATE_LOGIN NUMBER
Yes Standard "who" column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DB_SERVICE_GUID
,      DB_GUID
,      SERVICE_NAME
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_DATABASE_SERVICES;

Dependencies

[top of page]

APPLSYS.FND_DATABASE_SERVICES does not reference any database object

APPLSYS.FND_DATABASE_SERVICES is referenced by following:

SchemaAPPS
SynonymFND_DATABASE_SERVICES