- 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.
------------------------- JAVA CLASS object_name ------------------------- /11d378b4_LDAPResponseListene
What do these things mean?
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
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.