Ada bbrp objek yg tidak ada pas waktu menjalankan sqlplus. Biasanya karena objectnya atau privilegenya hilang. Apakah database 10g-nya adalah hasil upgrade dr versi sebelumnya?
Utk kasus ini, aku prefer utk menjalankan script utk recreate dictionary (soalnya mungkin bukan cuma sqlplus saja yg ter-impact). - Login sebagai user SYS - jalankan script catalog.sql dan catproc.sql spool catalog.log @?/rdbms/admin/catalog.sql @?/rdbms/admin/catproc.sql spool off --> cek file catalog.log apabila ada error yg abnormal - Compile ulang objek yg tidak valid @?/rdbms/admin/utlrp.sql regards, tomi --- Safik <[EMAIL PROTECTED]> wrote: > Mohon pencerahannya... kira2 kalo errornya kaya gini > kenapa yah ..? > Error ini muncul pada saat saya login ke db dr > sqlplus.. > Errornya .. > > SQL*Plus: Release 10.2.0.1.0 - Production on Sat Aug > 26 12:40:47 2006 > > Copyright (c) 1982, 2005, Oracle. All rights > reserved. > > ERROR: > ORA-18008: cannot find OUTLN schema > > > Error accessing PRODUCT_USER_PROFILE > Warning: Product user profile information not > loaded! > You may need to run PUPBLD.SQL as SYSTEM > ERROR: > ORA-18008: cannot find OUTLN schema > > > Error accessing package DBMS_APPLICATION_INFO > SP2-0575: Use of Oracle SQL feature not in SQL92 > Entry Level. > > Connected to: > Oracle Database 10g Enterprise Edition Release > 10.2.0.1.0 - Production > With the Partitioning, OLAP and Data Mining options __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
