Oracle - Errores y soluciones

Ratio: 4 / 5

ORA-01062: unable to allocate memory for define buffer.

Cause: Exceeded the maximum buffer size for current plaform.

Action: Use piecewise fetch with a smaller buffer size.

Ratio: 4 / 5

ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege.

Cause: Logins are disallowed because an instance started in restricted mode. Only users with RESTRICTED SESSION system privilege can log on.

Action: Request that Oracle be restarted without the restricted option or obtain the RESTRICTED SESSION system privilege.

Ratio: 4 / 5

ORA-01038: cannot write database file version string with ORACLE version string

Cause: Attempting to write datafile headers in an old format. The new format can not be used until after the database has been verified as being compatible with this software version.

Action: Open the database to advance to the new file formats, then repeat the operation. If the operation is required before the database can be opened, then use the previous software release to do the operation.

Ratio: 4 / 5

ORA-01039: insufficient privileges on underlying objects of the view

Cause: Attempting to explain plan on other people's view without the necessary privileges on the underlying objects of the view.

Action: Get necessary privileges or do not perform the offending operation.

Ratio: 4 / 5

ORA-01040: invalid character in password; logon denied

Cause: There are multibyte characters in the password or some characters in the password are not in US7ASCII range.

Action: Resubmit password with valid characters.

Ratio: 4 / 5

ORA-01042: detaching a session with open cursors not allowed

Cause: An attempt was made to detach a seesio n which had open cursors.

Action: Close all the cursors before detaching the session.