ORA-22931: MOVE of nested table to a different tablespace not supported

ORA-22931: MOVE of nested table to a different tablespace not supported

Cause: Attempt to move a nested table to a different tablespace.

Action: Nested tables always colocate in the same tablespace as the parent. A nested table can be moved to a different tablespace only by moving its containing table to the target tablespace.

ORA-22930: directory does not exist

ORA-22930: directory does not exist

Cause: Attempt to access a directory that does not exist.

Action: Make sure the name is correct.

ORA-22929: invalid or missing directory name

ORA-22929: invalid or missing directory name

Cause: The required directory name is invalid or missing.

Action: Specify a valid name.

ORA-22928: invalid privilege on directories

ORA-22928: invalid privilege on directories

Cause: An attempt was made to grant or revoke an invalid privilege on a directory.

Action: Only CREATE, DELETE, READ and WRITE privileges can be granted or revoked on directories. Do not grant or revoke other privileges.

ORA-22927: invalid LOB locator specified

ORA-22927: invalid LOB locator specified

Cause: There are several causes: (1) the LOB locator was never initialized; (2) the locator is for a BFILE and the routine expects a BLOB or CLOB or NCLOB locator; (3) the locator is for a BLOB or CLOB or NCLOB and the routine expects a BFILE locator; (4) trying to update the LOB in a trigger body --LOBs in trigger bodies are read only.

Action: For (1), initialize the LOB locator by selecting into the locator variable or by setting the LOB locator to empty. For (2) and (3), pass the correct type of locator into the routine. For (4), remove the trigger body code that updates the LOB value.

ORA-22926: specified trim length is greater than current LOB value s length

ORA-22926: specified trim length is greater than current LOB value s length

Cause: The input length for which to trim the LOB value to is greater than the current length of the LOB value.

Action: May not need to trim the LOB value because it s already smaller than the trim length specified. Or, if trimming the LOB value really is required, use a smaller trim length.

ORA-22925: operation would exceed maximum size allowed for a LOB value

ORA-22925: operation would exceed maximum size allowed for a LOB value

Cause: Trying to write too much data to the LOB value. LOB size is limited to 4 gigabytes.

Action: Either start writing at a smaller LOB offset or write less data to the LOB value.