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 : 24-05-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-06142 : NETTCP: error getting user information
  • ora-31183 : Node type string cannot be converted to desired type
  • ora-02435 : cannot disable unique(string) - unique key not defined for table
  • ora-08181 : specified number is not a valid system change number
  • ora-32839 : property string is reserved, names with MGWPROP$_ prefix are not valid
  • ora-13045 : invalid compatibility flag
  • ora-25119 : LOGGING/NOLOGGING option already specified
  • ora-00395 : online logs for the clone database must be renamed
  • ora-13857 : Invalid module name
  • ora-12534 : TNS:operation not supported
  • ora-02232 : invalid MOUNT mode
  • ora-28656 : incomplete attribute specification
  • ora-27198 : skgfpvl: sbtpcvalidate returned error
  • ora-29867 : cannot create a domain index on a LONG column
  • ora-14178 : STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes
  • ora-10584 : Can not invoke parallel recovery for test recovery
  • ora-22983 : not a user-defined REF
  • ora-16739 : redo transport service for standby database "string" unexpectedly online
  • ora-00163 : internal database name length string is greater than maximum (string)
  • ora-19242 : XQ0022 - namespace declaration attribute must be a literal
  • ora-19550 : cannot use backup/restore functions while using dispatcher
  • ora-14312 : Value string already exists in partition string
  • ora-09756 : osnpns: no port in the name server.
  • ora-39146 : schema "string" does not exist
  • ora-07459 : cannot restore the RESOURCE_MANAGER_PLAN parameter
  • ora-22858 : invalid alteration of datatype
  • ora-36188 : (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.
  • ora-30746 : error occured while trying to drop column "string" in table "string"
  • ora-15201 : disk string contains a valid RDBMS file
  • ora-06537 : OUT bind variable bound to an IN position
  • 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.