Skip to content
  • About
Search
Close

Geodata Master

Oracle Database Technical Articles & GeoSpatial Data Technology

Tag: oracle error ORA-13203

Oracle Spatial famous error ORA-13203: failed to read USER_SDO_GEOM_METADATA view

August 3, 2015June 10, 2019 arcsdegeoLeave a comment

One of the common errors faced by DBA’s/Oracle Spatial analysts is the following error:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

ORA-13203: failed to read USER_SDO_GEOM_METADATA view

ORA-13203: failed to read USER_SDO_GEOM_METADATA view

ORA-06512: at “MDSYS.SDO_INDEX_METHOD_10I”, line 10

the reason i am writing about it is to help the community and new analysts to Oracle spatial to fix this problem in speedy manner.

SO the solution:

before creating the spatial index you need to update(insert) in the USER_SDO_GEOM_METADATA view, this is required for each new layer being created.

USER_SDO_GEOM_METADATA contains metadata information for all spatial tables owned by the user.the view contains information about, for example:

insert into MDSYS.user_sdo_geom_metadata

(table_name, column_name, diminfo, srid)

values (‘GEO_TST’,’SHAPE1′, sdo_dim_array(sdo_dim_element(‘X’,0,20,0.005), sdo_dim_element(‘Y’,0,20,0.005) ), null );

Also, make sure that when you create the index afterwards…the account you are using has explicit “CREATE TABLE” & “CREATE SEQUENCE” privileges granted to it. Otherwise you will receive the following errors:

ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in R-tree: [mdrcrtscrt]
ORA-13231: failed to create index table [MDRS_13A71$] during R-tree creation
ORA-13249: Stmt-Execute Failure: CREATE SEQUENCE “HR”.”MDRS_13A71$” ORDER START WITH 1 CACHE 100
ORA-29400: data cartridge error
ORA-01031: insufficient privileges
ORA-06512: at “MDSYS.SDO_INDEX_METHOD_10I”, line 10

 

 

Advertisement

Blog Stats

  • 750,941 hits

Recent Posts

  • Oracle Database 23c Schema-Level Privileges
  • Storing Oracle AWR snapshots in User Defined Tablespace (Non-SYSAUX tablespace)
  • Oracle Database DATAPATCH Parameters and Pre-requisite Check (sanity_checks)
  • Oracle Database Listener Log Rotation
  • Oracle data patch error Archived patch directory is empty
Follow Geodata Master on WordPress.com

Top Posts & Pages

  • Oracle Database Product Life Cycle Support 19c,18c, 12cR2 Long Term & Innovation Releases !
  • RMAN List Backup Summary command
  • Oracle PDB and when is DAPTATCH required to be executed
  • Performing Import Data Pump with EXCLUDE=STATISTICS
  • location of Oracle SQL Developer Connections File
  • ora-28031 maximum of 148 enabled roles exceeded
  • export data pump errors ORA-39014 ORA-39029 ORA-31671 ORA-04030
  • ORA-04063: package body "SYS.DBMS_DATAPUMP" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_DATAPUMP" ORA-06512: at line 6
  • converting BLOB to CLOB datatype in oracle
  • set define off and '&' in your SQL Code

Archives

  • April 2023
  • January 2023
  • December 2022
  • October 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • March 2022
  • February 2022
  • January 2022
  • October 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • April 2020
  • March 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013

Recent Comments

Troubleshooting SYSA… on Oracle SYSAUX size is exponent…
Juan Aguilera Abarzu… on ORA-31633: unable to create ma…
Beau S on Oracle PSU July 2018 error…
Jeffrey on In-Memory Database Management…
Oracle Database Immu… on Oracle Database 19c Blockchain…

Search in my blog

Follow Geodata Master on WordPress.com

Top Posts & Pages

  • Oracle Database Product Life Cycle Support 19c,18c, 12cR2 Long Term & Innovation Releases !
  • RMAN List Backup Summary command
  • Oracle PDB and when is DAPTATCH required to be executed
  • Performing Import Data Pump with EXCLUDE=STATISTICS
  • location of Oracle SQL Developer Connections File
  • ora-28031 maximum of 148 enabled roles exceeded
  • export data pump errors ORA-39014 ORA-39029 ORA-31671 ORA-04030
  • ORA-04063: package body "SYS.DBMS_DATAPUMP" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_DATAPUMP" ORA-06512: at line 6
  • converting BLOB to CLOB datatype in oracle
  • set define off and '&' in your SQL Code

Blog Stats

  • 750,941 hits

Archives

  • April 2023
  • January 2023
  • December 2022
  • October 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • March 2022
  • February 2022
  • January 2022
  • October 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • April 2020
  • March 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
Blog at WordPress.com.
Back to top
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Geodata Master
    • Join 27 other followers
    • Already have a WordPress.com account? Log in now.
    • Geodata Master
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar