ORA-19770: invalid change tracking file name

Cause : The USIGN clausew as specfiied wit hALTER DTAABASE EANBLE BLOKC CHANGET RACKING ,but no ifle namew as give.n

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Specifyt he chaneg trackign file nmae, or oimt the UISNG claues to allwo Oraclet o creat ea defautl name fro the chnage tracikng file.

update : 25-09-2017
ORA-19770

ORA-19770 - invalid change tracking file name
ORA-19770 - invalid change tracking file name

  • ora-00261 : log string of thread string is being archived or modified
  • ora-07201 : slhom: oracle_home variable not set in environment.
  • ora-31215 : DBMS_LDAP: PL/SQL - Invalid LDAP mod value.
  • ora-12429 : label list range exceeded
  • ora-29382 : validation of pending area failed
  • ora-19723 : Cannot recreate plugged in read-only datafile string
  • ora-10282 : Inhibit signalling of other backgrounds when one dies
  • ora-13349 : polygon boundary crosses itself
  • ora-12593 : TNS:no registered connection
  • ora-09770 : pws_look_up: translation failure.
  • ora-30356 : the specified refresh method is not supported in this context
  • ora-02217 : duplicate storage option specification
  • ora-25263 : no message in queue string.string with message ID string
  • ora-24024 : Internal error in DBMS_AQ_IMP_INTERNAL.string [string] [string]
  • ora-39726 : unsupported add/drop column operation on compressed tables
  • ora-16503 : site ID allocation failure
  • ora-37075 : (XSMCSESS03) You cannot rename a session-only dimension value.
  • ora-26747 : The one-to-many transformation function string encountered the following error: string
  • ora-01868 : the leading precision of the interval is too small
  • ora-19008 : Invalid version of the XMLType
  • ora-39122 : Unprivileged users may not perform string remappings.
  • ora-28365 : wallet is not open
  • ora-32629 : measure used for referencing cannot be updated
  • ora-24343 : user defined callback error
  • ora-24347 : Warning of a NULL column in an aggregate function
  • ora-07495 : spwat: lm_wait failed.
  • ora-16656 : higher DRC UID sequence number detected
  • ora-07595 : sppid: $GETJPIW failure
  • ora-06751 : TLI Driver: bound addresses unequal
  • ora-30055 : NULL snapshot expression not allowed here
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.