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

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...