ORA-19773: must specify change tracking file name

Cause : No fil ename wsa speciifed wit hthe ALETR DATAABSE ENALBE CHANEG TRACKNIG commnad, andt he DB_RCEATE_FLIE_DESTp arametre was nto set.

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

Eithers pecifya file anme, ors et theD B_CREAET_FILE_EDST parmaeter.

update : 27-06-2017

ORA-19773 - must specify change tracking file name
ORA-19773 - must specify change tracking file name

  • ora-01085 : preceding errors in deferred rpc to "string.string.string"
  • ora-03293 : Cluster to be truncated is a HASH CLUSTER
  • ora-36863 : (XSTFRC03) The OLAPRC_TABLE function encountered an error while parsing the COLUMNMAP.
  • ora-37130 : (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because you must specify AGGINDEX OFF when there is a PRECOMPUTE clause on a RELATION over base workspace object.
  • ora-25270 : sender info does not match with the actual sender of the message
  • ora-01239 : database must be in ARCHIVELOG mode to use external cache
  • ora-24239 : object could not be invalidated
  • ora-38737 : Expected sequence number string doesn't match string
  • ora-38414 : invalid datatype for the attribute string
  • ora-03278 : duplicate ALLOCATE EXTENT option specification
  • ora-32615 : incorrect use of MODEL IS ANY predicate
  • ora-02337 : not an object type column
  • ora-33338 : (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.
  • ora-38793 : cannot FLASHBACK the database to a future SCN/time
  • ora-02752 : osnfsmmap: illegal shared memory address
  • ora-33008 : (XSAGDNGL03) The relation workspace object is not a relation over a base dimension of AGGMAP workspace object.
  • ora-31427 : publication string already subscribed
  • ora-08323 : scnmin: close of bias lock failed
  • ora-39134 : Cannot include "string" tablespace as a Transportable Tablespace
  • ora-16577 : corruption detected in Data Guard configuration file
  • ora-07282 : sksaprd: string overflow.
  • ora-09283 : sllfsk: error skipping records
  • ora-12421 : different size binary labels
  • ora-01617 : cannot mount: string is not a valid thread number
  • ora-13345 : a compound polygon geometry has fewer than five coordinates
  • ora-33911 : (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string.
  • ora-13239 : sdo_dimensionality not specified during n-d R-tree creation
  • ora-04088 : error during execution of trigger 'string.string'
  • ora-22287 : invalid or modified directory occurred during string operation
  • ora-28276 : Invalid ORACLE password attribute.
  • 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.