Oracle Files Administration Guide 9.0.3 Part Number A97358-01 |
|
| View PDF |
This appendix describes the eight SQL views installed with Oracle Files. Topics include:
Oracle Files provides eight SQL views that you can examine to see the effects of changes made to the Oracle Files schema. For example, if you use XML to quickly add new users, you can examine the view to confirm the changes. Typically, you would use the views as you're developing and debugging custom code. The views provide a means to confirm programmatic changes to the schema.
The eight default views are owned by the Oracle Files schema owner, ifssys
(default schema name; yours may be different). These read-only SQL views are created with the Oracle Files schema and are for informational purposes only. Grant the SELECT permission to users who need access to these views.
The names of objects in the view may not be unique. Therefore, IDs are provided. Any column of type date
has two columns in the view, for example:
CREATE_DATE
--An internal representation of the create date.CREATE_DATE_GMT
--The standard Oracle9i platform date format, based on Greenwich Mean Time.These eight schema views are provided. Each view is described in a separate table which provides the name of the column, whether the column can be null, the type of column, and the length for each column.
View: ifs_versioned_documents
View: ifs_all_documents
View: ifs_folders
View: ifs_folder_items
View: ifs_users
View: ifs_groups
View: ifs_group_members
View: ifs_acls
This view shows a list of all documents which are versioned.
This view shows a list of all documents.
This view shows all folders and their attributes.
This view lists all folders and the top level items.
This view lists all users.
This view lists all groups.
This view lists groups and their direct members.
This view lists all ACLs in Oracle Files.
This example uses ifs_versioned_documents
to select attributes. To accomplish this, the following command is run:
SQL> select name, format, document_size, media, document_id, acl, owner from
ifs_versioned_documents
The following table displays the output.