ORA-34900: (PPWKDAYS00) At least 7 day names must be given. Only number were provided.

Cause : There must be at least one name for each day. Not enough names were provided.

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

Make sure there are at least 7 names in the string.

update : 27-04-2017
ORA-34900

ORA-34900 - (PPWKDAYS00) At least 7 day names must be given. Only number were provided.
ORA-34900 - (PPWKDAYS00) At least 7 day names must be given. Only number were provided.

  • ora-19594 : control file already included as string
  • ora-31215 : DBMS_LDAP: PL/SQL - Invalid LDAP mod value.
  • ora-27033 : failed to obtain file size limit
  • ora-16740 : redo transport service for standby database "string" incorrectly set to ALTERNATE
  • ora-29810 : inadequate operator privileges
  • ora-01192 : must have at least one enabled thread
  • ora-13627 : Setting of parameter string is disallowed until the task is reset.
  • ora-19616 : output filename must be specified if database not mounted
  • ora-02219 : invalid NEXT storage option value
  • ora-08116 : can not acquire dml enough lock(S mode) for online index build
  • ora-08114 : can not alter a fake index
  • ora-01854 : julian date must be between 1 and 5373484
  • ora-02339 : invalid column specification
  • ora-08199 : Flashback Table operation is not supported on this object
  • ora-16660 : FSFO operation attempted in absence of a broker configuration
  • ora-19678 : RMAN configuration value exceeds maximum length of string
  • ora-06720 : TLI Driver: SID lookup failure
  • ora-02435 : cannot disable unique(string) - unique key not defined for table
  • ora-16057 : DGID from server not in Data Guard configuration
  • ora-30563 : outer join operator (+) not allowed in select-list
  • ora-01323 : Invalid state
  • ora-08232 : smsdes: cannot detach from SGA
  • ora-24155 : rule string.string not in rule set string.string
  • ora-13859 : Action cannot be specified without the module specification
  • ora-07844 : sllfop: LIB$GET_VM failure
  • ora-39954 : DEFERRED is required for this system parameter
  • ora-31109 : Action failed as parent resource string is locked
  • ora-14614 : List value 'string' specified twice in subpartition 'string'
  • ora-06802 : TLI Driver: could not open the /etc/netware/yellowpages file
  • ora-01272 : REUSE only allowed when a file name is provided.
  • 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.