ORA-00981: cannot mix table and system auditing options
Cause: Table and system-wide auditing options were specified in the same AUDIT or NOAUDIT statement
Action: You must issue table and system options in separate statements
All posts by mpbod
ORA-00980: synonym translation is no longer valid
ORA-00980: synonym translation is no longer valid
Cause: The synonym used is based on a table, view, or synonym that no longer exists
Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym
ORA-00979: not a GROUP BY expression
ORA-00979: not a GROUP BY expression
Cause: The GROUP BY clause does not contain all the expressions in the SELECT clause. SELECT expressions that are not included in a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, must be listed in the GROUP BY clause
Action: Include in the GROUP BY clause all SELECT expressions that are not group function arguments
ORA-00978: nested group function without GROUP BY
ORA-00978: nested group function without GROUP BY
Cause: A group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, was used within another group function, as in MAX(COUNT(*)), without a corresponding GROUP BY clause
Action: Either add a GROUP BY clause or remove the extra level of nesting
ORA-00977: duplicate auditing option
ORA-00977: duplicate auditing option
Cause: AUDIT or NOAUDIT statement specifies an option more than once
Action: Either use ALL with no other auditing options or make sure no option is listed more than once
ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here
ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here
Cause: LEVEL, PRIOR, or ROWNUM is being specified at illegal location
Action: Remove LEVEL, PRIOR, or ROWNUM
ORA-00975: date + date not allowed
ORA-00975: date + date not allowed
Cause: An attempt was made to add two date fields together. Dates may be added only to numeric fields, not to other dates
Action: Use the Oracle function TO_NUMBER to convert one of the date fields to a numeric field before adding it to the other date field
ORA-00974: invalid PCTFREE value (percentage)
ORA-00974: invalid PCTFREE value (percentage)
Cause: The percentage of free space specified in a CREATE INDEX statement is not between 0 and 100. A PCTFREE value of 0 means the entire block is available. The value 100 is not useful because it means that no data may be inserted. The default is 10
Action: Specify a PCTFREE value between 0 and 100. Then retry the statement
ORA-00973: invalid row count estimate
ORA-00973: invalid row count estimate
Cause:
Action:
ORA-00972: identifier is too long
ORA-00972: identifier is too long
Cause: An identifier with more than 30 characters was specified
Action: Specify at most 30 characters