A new version of the Google Site Search module for Joomla 2.5 was published get more infos here.

IT-Blog

how to compile invalid sys-objects

After installing a database sometimes sys objects are invalid, and don't recompile. In this case you have to use the script utlrp.sql. You can find this script on the database-machine in the RDBMS-directory where the oracle-software is installed for example C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN. These scripts sometimes don't work with sql-tools. So i prefer to use plain SQLPLUS on the machine directly. Just connect as SYS and execute the scripts like this:

  • cd C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN
  • SET ORACLE_SID=STRANGEDATABASE 
  • sqlplus sys/change_on_install as sysdba
  • start utlrp.sql

  • ramana

    Posted at 2009-09-08 11:14:04

    HI,
    Dear Sir,

    I trying to compile sys objects but some of my sys objs are not compiling.i have tried utlrp.sql but still iam getting same problem.

    kindly suggest me solution

    Thanks & Regards
    Ramana

    Auf Kommentar antworten

Veröffentlichen Sie ihre Kommentare ...


Warning: Creating default object from empty value in /www/htdocs/w0101274/www/fairtec.at/modules/mod_udjacomments/helper.php on line 387