Saturday, July 11, 2009

List of Database Properties

List of Database Properties
  • DBTIMEZONE -07:00 DB time zone
  • DEFAULT_PERMANENT_TABLESPACE SYSTEM Default Permanent Tablespace ID
  • DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
  • DEFAULT_TEMP_TABLESPACE TEMP1 Name of default temporary tablespace
  • DICT.BASE 2 dictionary base tables version #
  • EXPORT_VIEWS_VERSION 8 Export views revision #
  • GLOBAL_DB_NAME TESTING.KNM.COM Global database name
  • NLS_CALENDAR GREGORIAN Calendar system
  • NLS_CHARACTERSET US7ASCII Character set
  • NLS_COMP BINARY NLS comparison
  • NLS_CURRENCY $ Local currency
  • NLS_DATE_FORMAT DD-MON-RR Date format
  • NLS_DATE_LANGUAGE AMERICAN Date language
  • NLS_DUAL_CURRENCY $ Dual currency symbol
  • NLS_ISO_CURRENCY AMERICA ISO currency
  • NLS_LANGUAGE AMERICAN Language
  • NLS_LENGTH_SEMANTICS BYTE NLS length semantics
  • NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set
  • NLS_NCHAR_CONV_EXCP FALSE NLS conversion exception
  • NLS_NUMERIC_CHARACTERS ., Numeric characters
  • NLS_RDBMS_VERSION 10.2.0.2.0 RDBMS version for NLS parameters
  • NLS_SORT BINARY Linguistic definition
  • NLS_TERRITORY AMERICA Territory
  • NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM Time stamp format
  • NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR Timestamp with timezone format
  • NLS_TIME_FORMAT HH.MI.SSXFF AM Time format
  • NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR Time with timezone format

No comments:

Post a Comment

Troubleshooting ACFS-07981: Metadata Validation Errors

  Troubleshooting ACFS-07981: Metadata Validation Errors Introduction The ACFS-07981 error indicates that an attempt to run an online file ...