Internal Error Code Arguments 15264
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up oracle drop table cascade constraints statement hanging up vote 1 down vote favorite I'm issuing a simple drop table cascade constraints table , but it is hanging forever. After waiting for hours, if I press the cancel button in the SQL Developer, it says "User cancelled operation" like I'm the culprit. Please advice, before I shoot myself. After hanging for a long time it pops up a dialog box as follows: Error encountered: An error was encountered performing the requested operation: ORA-00600: internal error code, arguments: [15264],[],[],[],[],[],[],[] *Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional conndition oracle constraints sql-drop ora-00600 share|improve this question edited Mar 28 '14 at 22:19 Kara 3,16373147 asked Mar 30 '11 at 18:18 Hugh Darling 45651436 After hanging for a long time it pops up a dialog box as follows: Error encountered: An error was encountered performing the requested operation: ORA-00600: internal error code, arguments: [15264],[],[],[],[],[],[],[] *Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional conndition. –Hugh Darling Mar 30 '11 at 18:23 would you maybe give some details about what it is you're dropping? (and define "forever")? –Mat Mar 30 '11 at 18:24 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted In the first place, if an operation seems to be hanging, a wise thing
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | http://stackoverflow.com/questions/5490440/oracle-drop-table-cascade-constraints-statement-hanging Question Most of my databases are on version 12.1 11.2 11.1 10.2 10.1 or lower Answer and see the results DBA Top 10 1 M. Cadot 37400 2 F. Diaz 33800 3 J. Schnackenberg 17800 4 B. Vroman 15850 5 A. Kavsek 15350 6 P. Wisse 14150 7 T. Boles 13500 8 M. Hidayathullah ... 11300 9 A. Hudspith 9200 10 K. Subramaniam 4100 http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=40295 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47786Total active users2111Act. users last 24h20Act. users last hour0Registered user hits last week525Registered user hits last month6331 Go up ORA-00600: internal error code Next thread: connection alive problem in ORACLE Prev thread: Oracle 11gR1 Data Guard Switch over running very slow: 15+ minutes Message Score Author Date Hi, When we drop a table,The error ORA-0060...... shahul hameed May 21, 2010, 07:11 You have to call Oracle or search on Metalink fo...... Michel Cadot May 21, 2010, 08:31 Search for ORA 600 and argument appeared in the er...... Dev Shah May 21, 2010, 09:15 Use the Error Lookup Tool on Metalink, doc id 1537...... Johan Lorier May 21, 2010, 09:43 Follow up by mail Click here Subject: ORA-00600: internal error code Author: shahul hameed, India Date: May 21, 2010, 07:11, 2342 days ago Os info: Hp-UNIX 11.11 Oracle info: oracle 10.2.0.4.0 Error info: DROP TABLE MTHLY_RX_DATA Error report: SQL Error: ORA-00600: internal error code, arguments: [15264], [], [], [], [], [], [], [] 00600
[ID 338953.1] 修改时间 10-APR-2012 类型 PROBLEM 状态 PUBLISHED In this DocumentSymptomsChangesCauseSolutionReferences Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.5 - Release: 10.1 to 10.2Information in this document applies to any platform.*** Checked for http://m.blog.itpub.net/17252115/viewspace-732961/ relevance on 10-APR-2012 *** Symptoms You tried to drop a table and the DROP TABLE SQL command failed by raising an ORA-600 [15264].The trace file generated at that time shows:ORA-00600: internal error code, arguments: [15264], [], [], [], [], [], [], []Current SQL statement for this session:drop table ... And Call Stack contains: ... kkdldidRecycle ... Trying to drop the internal error indexes may give ORA-01418: specified index does not exist. ChangesThe drop of the table was interrupted and then reattempted. CauseThe exact cause is not all identified but this has most probably to do with the 10g recyclebin.Bugs have been logged for similar issues, but closed with a status 'could not reproduce'. Solution Although the root cause is unknown, we suggest that internal error code you: -> 1/ Log as sysdba and execute the following SQL command: SQL> PURGE RECYCLEBIN;This will purge your recycle bin and should return the following message: Recyclebin purged.-> 2/ Being logged as sysdba, execute now the following SQL command: SQL> PURGE DBA_RECYCLEBIN;This purges the DBA recycle bin and returns the following message: DBA Recyclebin purged.Then, you should be able to remove the table without encountering the ORA-600 [15264]-> 3/ In other words, re-try the same operation that failed earlier: SQL> DROP TABLE ... ; -> 4/ If this still fails, bounce (shutdown & restart) the database and retry again the same drop command. -> 5/ If the database bounce did not help: in 10gR1: set the init.ora parameter "_recyclebin" = false, bounce the database and try again the same drop. in 10gR2 Run the following command: SQL> ALTER SESSION SET RECYCLEBIN=OFF; and try again the same drop. ReferencesNOTE:265253.1 - 10g Recyclebin Features And How To Disable it( _recyclebin )NOTE:278623.1 - imdinst.sql=ORA=29809, deinssdo.sql=ORA-2303, drop user MDSYS=ORA-600[15264] 上一篇:oracle诊断工具-RDA使用 下一篇:Getting Ora-600 [kdsgrp1] On A Select [ID 429746.1] ITPUB论坛 | chinaunix博客 | chinaunix论坛 北京皓辰网域网络信息技术有限公司. 版权所有