Oracle Error Ora-29875
without it enabled. Please turn JavaScript back on and reload this page.All Places > GIS > Managing Data > DiscussionsLog in to create and rate content, and to follow, bookmark, and share content with other members.Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT routDiscussion created by mousaem on Feb 4, 2012Latest reply on Sep 10, 2012 by staspinar Like • Show 0 Likes0 Comment • 3Hi,i have a feature class that is versioned with st_geometry storage. when i try to edit it using ArcMap with an Oracle user that has the full editing privileges i receive the following error:Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT routineORA-00942: table or view does not existORA-06512: at "SDE.SPX_UTIL", line 925ORA-06512: at "SDE.SPX_UTIL", line 960ORA-06512 at "SDE.ST_DOMAIN_METHODS", line 1906however, when i try editing layer using the "schema owner", i don't receive this error !!! and editing works fine.My Geodatabase environment is:DBMS: Oracle 11g R2ArcSDE Version: ArcSDE 10 SP2Unix Server: IBM AIX 6.1The layers are hosted in a "user-schema geodatbase".Please check the attached error message.can somebody help?Thanks,AttachmentsERROR Message.jpg107.5 KBOutcomesVisibility: Managing Data4546 ViewsLast modified on Feb 4, 2012 6:27 PMTags:managing_dataContent tagged with managing_datagdbContent tagged with gdb_geodatabaseContent tagged with _geodatabaseThis content has been marked as final. Show 3 comments3 RepliesNameEmail AddressWebsite AddressName(Required)Email Address(Required, will not be published)Website Addressmvisekru Feb 6, 2012 5:43 AMHave you checked the SDE schema of the user-schema geodatabase for any invalid objects? I have come across this issue and resolved it by recompiling the SPX_UTIL package.Like • Show 0 Likes0 Actions mousaem Feb 6, 2012 6:09 PMThanks for your feedback.I did recompile SPX_UTIL package under "SDE" schema, and it recompiled successfully (it was not initially invalid).However, when i try to put the layer in ArcMap again i receive the following error:Error: ORA-29861: domain index is marked LOADI
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle https://geonet.esri.com/thread/98415 VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace https://community.oracle.com/community/developer/search.jspa?q=ORA-29875 depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
↓ Message: ORA-29875: failed in the execution of the ODCIINDEXINSERT routine Cause: Failed to successfully execute the ODCIIndexInsert routine. Action: oracle error Check to see if the routine has been coded correctly. Related ORA-01403: no data found › Posted in Uncategorized Contribute further information: Cancel reply Search ORA.codes Search oracle error ora-29875 for: Recent popular error codes ORA-24067: exceeded maximum number of subscribers for queue ... ORA-29270: too many open HTTP requests ORA-01403: no data found ORA-12805: parallel query server died unexpectedly ORA-10877: error signaled in parallel recovery slave ... ORA-39242: Unable to export/import ... due to table attributes. ORA-39046: Metadata remap ... has already been specified. TNS-03502: Insufficient arguments. Usage: tnsping
[in Home / *FME Desktop / Home / ORA-20092: Maximum number of grids per feature exceeded Export to PDF MitaAtSafe created · Oct 08, 2015 at 07:13 PM · edited · Jul 13 at 08:50 PM Article created with FME Desktop . Symptom The following warning in the FME log file results in data not being loaded to ArSDE: Feature will be lost. The error message was: "Error while executing stream insert operation for table 'TABLE1'.:SDE_ERROR_CODE(-51) Underlying DBMS error. SDE_EXT_ERROR(29875) SDE_ERROR_MSG1(ORA-29875: failed in the execution of the ODCIINDEXINSERT routine ORA-20092: Maximum number of grids per feature (8000) exceeded. ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 1982 Cause The SDE maximum grid size has been exceeded. ORA-20092: Oracle reserves ORA -20000 to -20999 numbers for "user specific error messages", so that applications can raise an application specific error (in this case it's SDE). PL/SQL is used to raise the errors. ORA-06512: indicates the line number of the PL/SQL code that raised the error. Resolution If writing to a new table the parameters grid 0, grid 1, grid 2 on the destination feature type allow you to adjust the grid size: Otherwise, create or adjust the grid size with ArcSDE commands. The following article describes ArcSDE grid size optimization: The Role of Grid Size Optimization in ArcSDE Performance Tuning. thub.nodes.view.add-new-comment databaseoraclearcsde Add comment 10 |1200 characters needed characters left characters exceeded ▼ Viewable by all users Viewable by moderators Viewable by moderators and the original poster Advanced visibility Viewable by all users Article Contributors Follow this article Follow No one has followed this yet. Navigation ORA-20092: Maximum number of grids per feature exceeded Related Articles Performing spatial queries on database tables using the FeatureReader Oracle Workspaces Not Handled by FME 2015 Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216072'. Underlying DBMS error[ORA-12637] FME is loading features with invalid geometries into my Database ArcSDE Case Sensitivity | Attributes Not Written Correctly to ArcSDE Oracle reader error ora-00904 invalid identifier MI_STYLE Reading Point Clouds Connect to an Oracle Service Name (not Oracle SID) Oracle Coordinate System Support My Oracle tables are not showing up in the table list © 2016 Safe Software Inc | Legal Powered by AnswerHub An