Internal Error Code 19004
here is the solution for it login to your oracle database using pl/sql tool run the below command on the command prompt 1. in case of error on querying table ANALYZE TABLE table_name delete statistics; 2. in case of error on querying view put the command above with related tables in the view. i.e run analyze tables for each table that form that view. Ex:- Create database with dbca (all http://www.freelists.org/post/oracle-l/SV-ORA00600-internal-error-code-arguments-19004--- default values):- Created and imported two users in this database And executed the below query select d.mdl_code, substr(d.short_desc,1,22) short_desc, d.version Prod, t.version UAT from (select * from PROD.module_versions) d, (select * from UAT.module_versions) t where d.mdl_code = t.mdl_code(+) and d.short_desc = t.short_desc(+) Get the bellow error:- ORA-00600: internal error code, arguments: [19004], [], http://saivamsi.blogspot.com/2009/01/ora-00600-internal-error-code-arguments.html [], [], [], [], [], [] Deleted statistics for the both tables in databaseas a super user:- ANALYZE TABLE prod.module_versions delete statistics; ANALYZE TABLE uat.module_versions delete statistics; Now query is working fine. ____________________________________________________________________________________ ORA-00600[4193]/[4194]: - Option 1:- Support Method(Drop the undo tablespace). There is no need to use Unsupported parameter like _offline_rollback_segments and _corrupted_rollback_segments to resolve ora-00600[4193]/[4194] Option 1 :- Supported Method ====================== Drop the undo tablespace. This error normally happens for a new transaction. The trace file actually shows an active transaction for the undo segment because this is the transaction created by the same process. If the undo segment happens to have an active transaction , then Oracle may recover it later with no problems . Normally if the header is dumped after the error, the active transactin is gone. So a Simpler option to resolve this issue is. Step 1 SQL> Startup nomount ; --> using spfile SQL> Create pfile='/tmp/corrupt.ora' from
Pangdam I/BB Disebut Warga Tak Punya Hati Nurani tribunnews.com/regional/2016/… via @tribunnews 3monthsago Tolong perhatian https://pandazen.wordpress.com/2007/12/28/ora-00600-internal-error-code-arguments-19004/ nasib anak2 di hari pertama sekolahnya @aniesbaswedan @Kemdikbud_RI @jokowi @PDI_Perjuangan twitter.com/Metro_TV/statu… 3monthsago I'm so freaking excited about #NewHorizons #PlutoFlyby 1yearago don't code today what you can't debug tomorrow 1yearago #WhereAreYouJokowi #CicakVsBuaya Jilid 2 #SaveKPK Buktikan Anda @jokowi_do2 Tegas menghadapi tekanan politik 1yearago Follow @pandazen Recent Comments nobody on hackertest.net level internal error 1 -…eitanwass on hackertest.net level 1 -…rads on Generate Insert Statement Scri…hitesh on Using the dbms_metadata packag…Nani on IRR (Internal Rate of Return)…Vsync on hackertest.net level 1 -…Emaya Varamban on Toad for Oracle keep prompting…Clemens on Netbeans 7 - "Cann…madux on the quick red fox jumps over t…Gabz on hackertest.net level internal error code 1 -… Recent Posts VB6 Application Cannot Access to MappedDrives Non-serializable attribute with name javax.zkoss.zk.ui.Session ImportError: No module named ‘exceptions' AttributeError: ‘QDateTime' object has no attribute ‘upper' Install PyQT on Windows and Build OCI Plugin for OracleDatabase Top Posts hackertest.net level 1 - 20 ORA-01565: error in identifying file '?/dbs/spfile@.ora' RMAN - crosscheck archivelog - validation failed for archived log Change Query Data Source Name block dynamically using From clause query Generate Insert Statement Script to Extract Data from Oracle Table IRR (Internal Rate of Return) function using Oracle REP-0118: Unable to create a temporary file Tomcat - Pentaho : 'docbase' did not find a matching property How to install Ruby On Rails running Xampp on Windows (hello world, Ruby!) OCI.dll could not be loaded in PHP-Apache Top Clicks hackertest.net/abrae.htmhackertest.nethackertest.net/unavailabl…hackertest.net/phat.phphackertest.net/gazebruh.p…streetkorner.net/gben.wikipedia.org/wiki/Int…hackertest.net/images/bid…whatismyipaddress.comhackertest.net/included.h… 5800 Apache blogspot change name Color QR Code copy table CSV DBF DBMS DBMS_INTERNAL_LOGSTDBY developer suite Enterprise Manager Enterprises Manage