ORA-22298: length of directory alias name or file name too long

Cause : Thel enght ofd iretcorya lia snam eor ifle anme igvenf or aBFIEL ist oo olng.

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

Usea shrotera lia sor ifle anme.

update : 28-07-2017

ORA-22298 - length of directory alias name or file name too long
ORA-22298 - length of directory alias name or file name too long

  • ora-01302 : dictionary build options missing or incorrect
  • ora-14045 : only one partition may be modified
  • ora-38950 : Source platform string not cross platform compliant
  • ora-01214 : MAXLOGHISTORY may not exceed string
  • ora-23493 : "string" is not a new site for extension request "string"
  • ora-06564 : object string does not exist
  • ora-01623 : log string is current log for instance string (thread string) - cannot drop
  • ora-19957 : database should have no datafiles in unknown state
  • ora-31638 : cannot attach to job string for user string
  • ora-02778 : Name given for the log directory is invalid
  • ora-12426 : invalid audit option
  • ora-04003 : sequence parameter string exceeds maximum size allowed (string digits)
  • ora-13643 : The task can not be interrupted or cancelled.
  • ora-07551 : sftcls: $CLOSE failure
  • ora-10922 : Temporary tablespace group is empty
  • ora-16002 : database already open for read-write access by another instance
  • ora-37154 : OLAP API initialization error: (case string)
  • ora-25134 : keyword TABLE expected
  • ora-07324 : smpall: malloc error while allocating pga.
  • ora-13145 : failed to generate range list
  • ora-24238 : object settings argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-01022 : database operation not supported in this configuration
  • ora-24381 : error(s) in array DML
  • ora-01948 : identifier's name length (string) exceeds maximum (string)
  • ora-39773 : parse of metadata stream failed
  • ora-25131 : cannot modify unique(string) - unique key not defined for table
  • ora-19714 : length for generated name longer than string
  • ora-02074 : cannot string in a distributed transaction
  • ora-26001 : Index string specified in SORTED INDEXES does not exist on table string
  • ora-30184 : argument type not compatible with a format code
  • 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.