Q
Problem solve Get help with specific problems with your technologies, process and projects.

What are next extent failures?

How to solve next extent failure objects? I have checked some invalid objects in my production database but I don't understand that object_type.

  1. How to solve next extent failure objects?
  2. I have checked some invalid objects in my production database but I don't understand that object_type.
-------------------------
JAVA CLASS 

 object_name
-------------------------
 /11d378b4_LDAPResponseListene 

What do these things mean?

Error messages about next extent failures mean that you need to add more space to the tablespace. This message is basically telling you there is not enough free space in the tablespace for an object to extend. To determine which tablespace the object resides in, type the following command into SQL*Plus with an account that has DBA privileges (assume the table is called TEST):
select tablespace_name from dba_tables where table_name='TEST';
Then determine how much free space is left in the tablespace with the following command (assume the above command returns a tablespace name of PROD_DATA):
select sum(bytes) from dba_free_space where tablespace_name='PROD_DATA';
With respect to your second question, those invalid objects are java classes and they get created a number of ways, one of which is installing the JVM inside of the database by running the initjvm.sql script. If you have invalid java classes, you can try recompiling them with the following command (remember to use double quotes or the statement will fail):
ALTER JAVA CLASS "/11d378b4_LDAPResponseListene" RESOLVE;

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close