Preface

This manual describes XBRL Extension to Oracle XML DB.

Audience

This manual is intended for developers building XBRL applications.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Related Documents

For more information, see the following Oracle resources:

  • Oracle XML DB Developer's Guide

  • Oracle XML Developer's Kit Programmer's Guide

To download free release notes, installation documentation, white papers, or other collateral material, visit Oracle Technology Network (OTN). You must register online before using OTN; registration is free and can be done at

http://www.oracle.com/technetwork/community/join/overview/index.html

If you have a username and password for OTN, then you can go directly to the documentation section of the OTN Web site at

http://www.oracle.com/technetwork/documentation/

For additional information, see:

Note:

Throughout this manual, "XML Schema" refers to the XML Schema 1.0 recommendation, http://www.w3.org/XML/Schema.

Placeholders in Oracle Database XBRL Extension Developer's Guide

The following placeholders are used in this book, in particular in Chapter 5, "Installing XBRL Extension to Oracle XML DB" and Chapter 4, "Administering XBRL Extension to Oracle XML DB".

  • sys_pass – System password.

  • xb_sys_pass – Password for database user XBRLSYS, which is the user that creates and administers all XBRL repositories.

  • xb_sys_ts – A tablespace for user XBRLSYS. For Oracle Database 11g Release 2 (11.2.0.2) or later, the tablespace must use automatic segment space management.

  • xb_sys_tmp_ts – A temporary tablespace for user XBRLSYS.

  • xb_rep – Name of an XBRL repository, which is also a database user name. (See "Creating an XBRL Repository".)

  • xb_rep_pass – Password for database user xb_rep.

  • xb_rep_ts – A tablespace for XBRL repository xb_rep. For Oracle Database 11g Release 2 (11.2.0.2) or later, the tablespace must use automatic segment space management.

  • xb_rep_idx_ts – Tablespace for the XMLIndex index storage tables for XBRL repository xb_rep.

  • xb_rep_tmp_ts – A temporary tablespace for XBRL repository xb_rep.

  • xb_protocols – Whether or not to use Oracle XML DB Repository to provide protocol access. TRUE means use it; FALSE means do not use it. If XBRL repository xb_rep is likely to contain more than 100,000 documents, then use FALSE for best performance.

  • obiee_home – Directory where Oracle Business Intelligence Suite Enterprise Edition (OBIEE) is installed.

  • obieedata_home – Directory where OBIEE data is stored.

  • oracle_client – Name of your Oracle client for OBIEE. For example, OracleClient11g_home1.

  • oracle_client_dir – Directory where your Oracle client for OBIEE is installed.

See Also:

Oracle Database Administrator's Guide for information about automatic segment space management

Conventions

The following text conventions are used in this document:

Convention Meaning
boldface Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

Code Examples

The code examples in this book are for illustration only. In many cases, however, you can copy and paste parts of examples and run them in your environment.

Pretty Printing of XML Data

To promote readability, especially of lengthy or complex XML data, output is sometimes shown pretty-printed (formatted) in code examples.

Reminder About Case Sensitivity

When examining the examples in this book, keep in mind the following:

  • SQL is case-insensitive, but names in SQL code are implicitly uppercase, unless you enclose them in double-quotes.

  • XML is case-sensitive. You must refer to SQL names in XML code using the correct case: uppercase SQL names must be written as uppercase.

For example, if you create a table named my_table in SQL without using double-quotes, then you must refer to it in XML code as "MY_TABLE".