Oracle Error Code 13356
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings ora-13349 and policies of this site About Us Learn more about Stack Overflow
Ora-13011
the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags
Oracle Spatial Fix Invalid Geometry
Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only
Sdo_geometry
takes a minute: Sign up 13356 error when validating point layer up vote 0 down vote favorite I get a 13356 error when validating a polyline layer. I know that I can use SDO_UTIL.REMOVE_DUPLICATE_VERTICES to fix the problem but how would I write the syntax for this polyline layer? +----------------------+----------------------------------------+ | SDO_ROWID | STATUS | +----------------------+----------------------------------------+ | (null) | Rows sdo_elem_info_array Processed <4035> | | AAA2EVAANAAB8ccAAJ | 13356 [Element <1>] [Coordinate <3>] | | AAA2EVAANAAB8cvAAK | 13356 [Element <1>] [Coordinate <5>] | | AAA2EVAANAAB8cwAAD | 13356 [Element <1>] [Coordinate <4>] | | AAA2EVAANAAB8dBAAJ | 13356 [Element <1>] [Coordinate <1>] | | AAA2EVAANAAB8dBAAO | 13356 [Element <1>] [Coordinate <4>] | | AAA2EVAANAAB8d/AAP | 13356 [Element <1>] [Coordinate <3>] | +----------------------+----------------------------------------+ Could I write a syntax like below: update my_geometries set geometry = sdo_util.remove_duplicate_vertices(geometry) where rowid in ( select sdo_rowid from GEOM_VALID_COLLECTORS --table that was created to store results where substr(status,1,5) = '13356' ); Then migrate to current revalidate again: --migrate to current EXECUTE SDO_MIGRATE.TO_CURRENT('OTTAWACOLLECTORS', 'GEOMETRY', 4035); --validate layer CREATE TABLE Geom_Valid_Collectors (SDO_ROWID ROWID, STATUS VARCHAR2(2000) ); --some error, go back because I did this with the buildings accidentally EXECUTE MDSYS.SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT ('OTTAWACOLLECTORS', 'GEOMETRY', 'Geom_Valid_Collectors'); SELECT * FROM Geom_Valid_Collectors; oracle oracle-spatial share|improve this question edited Jun 8 '15 at 20:03 asked Jun 8 '15 at 1:30 Toronto23 6411 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote Duplicate points in a point layer is not possible. Or are th
Create Polygon From Bearings AndDistances Function That Returns a Compass Point From a Whole CircleBearing Playing around with Centroids by using different seedvalues GeoRaptor 4.x Update2 Simple Oracle C Sprintf or Java String.format Some Oriented PointFunctions Extracting Inner Rings Changed Ordinate Ordering: A Trap For Players Who Don't ReadDocumentation! PLS-00306: wrong number or types of arguments in call to 'SDO_GEOMETRY' Converting Google Earth Formatted Longitude/Latitude points to decimaldegrees Oracle Business Intelligence Warehousing and Analytics - SpatialSummit How far inside, is inside? http://stackoverflow.com/questions/30700142/13356-error-when-validating-point-layer Measuring actualdistance. Noding and building a polygon from single, overlappinglinestrings Analyzing Spatial Query Performance Improvements in Oracle Spatial and Graph 12c Through Cross-VendorComparison ST_VertexN / ST_PointN - Extracting a specific point from anygeometry Convert Single Point stored in SDO_ORDINATES toSDO_POINT_TYPE Aggregate APPEND Islands and XORpolygons Circular Arcs in GeodeticPolygons Some SDO_GEOMETRY/DIMINFO handlingfunctions Applying And Extending https://spatialdbadvisor.com/oracle_spatial_tips_tricks/192/sdo_geomvalidate_geometry_with_context-13356-issues Oracle Spatial - BookReleased Changing all DIMINFO sdo_tolerance values for all metadata records in onego. Building Polygons from Incomplete Linestrings usingST_PolygonBuilder Computing Cardinal Directions to nearbygeometries Intersecting two aggregated polygon layers withSC4O Spatial and Oracle12c Update Triggers and SDO_GEOMETRYEquality Duplicate Geometry data and DataModels CENTROID packageupdate How to calculate cumulative length of alinestring Useful Package of Wrapper Functions for Sdo_Util.AffineTransforms Compute Location from known Lat/Long point using delta easting and northing inmiles SDO_AGGR_SET_UNION Sorting SDO_GEOMETRY data using the ORDER BY clause of a SELECTstatement Creating linestrings frompoints Rounding Coordinates or Ordinates inSDO_GEOMETRY Effects of Sdo_Geometry Ordinate Precision onPerformance Effects of Sdo_Geometry Ordinate Precision onStorage The Spatial filtering of geometries: The effect of tolerances onrelationships Application of Delaunay Triangulation and Inverse Distance Weighting (IDW) in Oracle for SoilsInterpolation Selecting all SDO_GTYPE values for all tables/sdo_geometry columns in aschema CENTROID package - Tips forUse Announcing the Spatial Companion For Oracle(SC4O) Filtering Rings (OracleSpatial) Splitting a polygon using one or morelinestrings isValid, isSimple, Dimension and CoordDim methods forSDO_Geome
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=ORA-13348 JavaScript enabled. This tool uses JavaScript https://www.oraexcel.com/oracle-11gR2-ORA-13356 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 oracle error 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 oracle error code 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
_Font family, color, and size _Custom cell format _Horizontal and vertical alignment _Bold, italic, and underline _Borders with styles and colors _Merge and align cells _Wrap text _Column width and row height _Multiple sheets _Multiple documents _Export from select _Add 1.048.576 rows to sheet _Save worksheet to XLSX file _Save worksheet to BLOB _Set sheet paper size _Left and right text indent _Unlimited sheets per document _Set cell background color _Set column width _Set row height _Set sheet margins _Set sheet header and footer text _Set cell comment _Filter cells _Rotate text _Hide columns and rows _Set column formulas _Set sheet portrait or landscape _Set cell as hyperlink _Group columns _Save BLOB to file _Freeze panes vertical _Freeze panes horizontal _Cell style _Set document author _Set date system _Read xlsx document _Set active cell _List - data validation _Whole number - data validation _Decimal number - data validation _Date - data validation _Time - data validation _Text length - data validation Documentation add_sheet add_row query_to_sheet set_row_height set_cell_value set_cell_font set_default_font set_cell_bold set_cell_italic set_cell_underline set_cell_color set_cell_bg_color set_cell_align_left set_cell_align_right set_cell_align_center set_cell_vert_align_top set_cell_vert_align_middle set_cell_vert_align_bottom set_column_width set_cell_border_top set_cell_border_bottom set_cell_border_left set_cell_border_right set_cell_border set_cell_wrap_text merge_cells merge_rows set_cell_format set_cell_formula set_cell_rotate_text set_sheet_margins set_sheet_landscape set_sheet_paper_size set_sheet_header_text set_sheet_footer_text set_cell_hyperlink set_cell_indent_left set_cell_indent_right set_cell_comment hide_column hide_row set_cells_filter save_to_file save_to_blob set_1904_date_system set_1900_date_system set_document_author add_style set_cell_style freeze_panes_horizontal freeze_panes_vertical blob_to_file group_columns set_cell_validation_list set_cell_validation_intege