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

TABLE: OTA.OTA_CONTENT_SERVERS

Object Details
Object Name: OTA_CONTENT_SERVERS
Object Type: TABLE
Owner: OTA
FND Design Data: TableOTA.OTA_CONTENT_SERVERS
Subobject Name:
Status: VALID


A content server is not required for Oracle iLearning, since learning objects can refer to content in one of two ways.
One method uses a URL to access content.
The other method is to setup a machine as a web server that will host physical content files.
In this case, a content server must be setup in Oracle iLearning to access this content.
The benefit of setting up a content server, is that administrators can upload content to the content server machine from within the Oracle iLearning interface.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OTA_CONTENT_SERVERS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTENT_SERVER_ID
Columns
Name Datatype Length Mandatory Comments
CONTENT_SERVER_ID NUMBER (15) Yes The system generated surrogatekey for this entry.
NAME VARCHAR2 (240) Yes Name of the Content Server
PROTOCOL VARCHAR2 (10) Yes Protocol for the Content Server.
HOST VARCHAR2 (240) Yes URL for the Content Server
PORT NUMBER (5) Yes Port where the Content server reside.
PHYSICAL_DIRECTORY VARCHAR2 (240) Yes Physical directory for the Content Server.
VIRTUAL_DIRECTORY VARCHAR2 (240) Yes Virtual Directory directory for the Content Server.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ALL_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Version control parameter
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CONTENT_SERVER_TYPE VARCHAR2 (1)
Indicates the type of content server
Query Text

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


SELECT CONTENT_SERVER_ID
,      NAME
,      PROTOCOL
,      HOST
,      PORT
,      PHYSICAL_DIRECTORY
,      VIRTUAL_DIRECTORY
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CONTENT_SERVER_TYPE
FROM OTA.OTA_CONTENT_SERVERS;

Dependencies

[top of page]

OTA.OTA_CONTENT_SERVERS does not reference any database object

OTA.OTA_CONTENT_SERVERS is referenced by following:

SchemaOTA
ViewOTA_CONTENT_SERVERS#