Documentation
Documentation generated on: 10/29/2008 10:27:25 PM
Database objects
| type | count |
|---|
| tables | 0 |
| views | 0 |
| indexes | 0 |
| materialized views | 0 |
| procedures | 0 |
| functions | 0 |
| triggers | 0 |
| packages | 0 |
| sequences | 0 |
| synonyms | 8 |
Schema properties
| name | value | comment |
|---|
| name | BI | this is the schema this documenation is for |
| server | ORCL | Oracle instance name |
| server version | 10.2.0.1.0
| the Oracle version number |
| DICT.BASE
| 2
| dictionary base tables version #
|
| DEFAULT_TEMP_TABLESPACE
| TEMP
| Name of default temporary tablespace
|
| DEFAULT_PERMANENT_TABLESPACE
| USERS
| Name of default permanent tablespace
|
| DEFAULT_TBS_TYPE
| SMALLFILE
| Default tablespace type
|
| NLS_LANGUAGE
| AMERICAN
| Language
|
| NLS_TERRITORY
| AMERICA
| Territory
|
| NLS_CURRENCY
| $
| Local currency
|
| NLS_ISO_CURRENCY
| AMERICA
| ISO currency
|
| NLS_NUMERIC_CHARACTERS
| .,
| Numeric characters
|
| NLS_CHARACTERSET
| WE8MSWIN1252
| Character set
|
| NLS_CALENDAR
| GREGORIAN
| Calendar system
|
| NLS_DATE_FORMAT
| DD-MON-RR
| Date format
|
| NLS_DATE_LANGUAGE
| AMERICAN
| Date language
|
| NLS_SORT
| BINARY
| Linguistic definition
|
| NLS_TIME_FORMAT
| HH.MI.SSXFF AM
| Time format
|
| NLS_TIMESTAMP_FORMAT
| DD-MON-RR HH.MI.SSXFF AM
| Time stamp format
|
| NLS_TIME_TZ_FORMAT
| HH.MI.SSXFF AM TZR
| Time with timezone format
|
| NLS_TIMESTAMP_TZ_FORMAT
| DD-MON-RR HH.MI.SSXFF AM TZR
| Timestamp with timezone format
|
| NLS_DUAL_CURRENCY
| $
| Dual currency symbol
|
| NLS_COMP
| BINARY
| NLS comparison
|
| NLS_LENGTH_SEMANTICS
| BYTE
| NLS length semantics
|
| NLS_NCHAR_CONV_EXCP
| FALSE
| NLS conversion exception
|
| NLS_NCHAR_CHARACTERSET
| AL16UTF16
| NCHAR Character set
|
| NLS_RDBMS_VERSION
| 10.2.0.1.0
| RDBMS version for NLS parameters
|
| GLOBAL_DB_NAME
| ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM
| Global database name
|
| EXPORT_VIEWS_VERSION
| 8
| Export views revision #
|
| DBTIMEZONE
| 00:00
| DB time zone
|
Server variables
| name | value | default | session modifiable | system modifiable | instance modifiable | modified | adjusted | deprecated | description |
|---|