Showing posts with label string). Show all posts
Showing posts with label string). Show all posts

Sunday, 13 May 2012

ORA-29338: datafile string is in an undesired state (string, string)

ORA-29338: datafile string is in an undesired state (string, string)

Cause: The referred datafile is not in a state ready for tablespace copy operation. For example, the datafile may be offline. The datafile needs to be ONLINE, and either READ ONLY or READ WRITE.

Action: Put the datafile into the desired state.

Friday, 11 May 2012

ORA-28606: block too fragmented to build bitmap index (string,string)

ORA-28606: block too fragmented to build bitmap index (string,string)

Cause: The block(s) exceed the maximum number of rows expected when creating a bitmap index. This is probably due to maximum slot allowed set too low. The values in the message are: (slot number found, maximum slot allowed)

Action: alter system flush shared_pool; update tab$ set spare1 = 8192 where obj# = (select obj# from obj$ where NAME=lamp;lt;lamp;nbsp;table_namelamp;gt; AND owner# = lamp;lt;lamp;nbsp;table_ ownerlamp;gt;; commit;

ORA-28604: table too fragmented to build bitmap index (string,string,string)

ORA-28604: table too fragmented to build bitmap index (string,string,string)

Cause: The table has one or more blocks that exceed the maximum number of rows expected when creating a bitmap index. This is probably due to deleted rows. The values in the message are: (data block address, slot number found, maximum slot allowed)

Action: Defragment the table or block(s). Use the values in the message to determine the FIRST block affected. (There may be others).

Saturday, 10 March 2012

ORA-13530: invalid TOPNSQL string, must be in the range (string, string)

ORA-13530: invalid TOPNSQL string, must be in the range (string, string)

Cause: The user has specified a TOPNSQL setting that is not in the supported range of (MIN, MAX).

Action: Choose a valid TOPNSQL setting and retry the operation.

ORA-13511: invalid INTERVAL string, must be in the range (string, string)

ORA-13511: invalid INTERVAL string, must be in the range (string, string)

Cause: The user has specified a INTERVAL setting that is not in the supported range of (MIN, MAX).

Action: Choose a valid INTERVAL setting and retry the operation.

ORA-13510: invalid RETENTION string, must be in the range (string, string)

ORA-13510: invalid RETENTION string, must be in the range (string, string)

Cause: The user has specified a RETENTION setting that is not in the supported range of (MIN, MAX).

Action: Choose a valid RETENTION setting and retry the operation.

ORA-13506: operation failed due to invalid snapshot range (string, string)

ORA-13506: operation failed due to invalid snapshot range (string, string)

Cause: An attempt was made to perform operation with an invalid Start or End Snapshot Pair.

Action: Choose a valid Start or End Snapshot Pair.

Wednesday, 1 February 2012

ORA-04030: out of process memory when trying to allocate string bytes (string,string)

ORA-04030: out of process memory when trying to allocate string bytes (string,string)

Cause: Operating system process private memory has been exhausted

Action: none

Tuesday, 3 January 2012

ORA-00064: object is too large to allocate on this O or S (string,string)

ORA-00064: object is too large to allocate on this O or S (string,string)

Cause: An initialization parameter was set to a value that required allocating more contiguous space than can be allocated on this operating system.

Action: Reduce the value of the initialization parameter.