http://iotn.co.kr ¿¬¶ôó: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / ìíÜâïÙݤªÏìíÜâÏÚªÎàõîÜÒ¿ÖË?ßåíºªËÞóñªª¹ªÙª­. ]

»ç¿ëÀÚ

ID:
PW:

INDEX
01.°Ô½ÃÆÇ
°Ô½ÃÆÇ [71]
02.File Book
File ÀÚ·á½Ç [95]
Site Link [17]
°³ÀÎÆú´õ [201]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [43]
DB2 [79]
ORACLE [2973]
PSQL [133]
±âŸÁ¤º¸ [155]
¿î¿µÃ¼Á¦ [600]
04.Q/A Book
Q/A [53]
05.¹æ¸í·Ï
¹æ¸í·Ï [54]
·¹º§¾÷ [37]
±¸ÀÎ/±¸Á÷ [2]

±â³äÀÏ
Search
LINK
+ °¡Á· Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 È¸¿ø°¡ÀÔ

ORA-13203: failed to read USER_SDO_GEOM_METADATA view
ÃÖ±æÈ£ [LIST]   2022-06-14 17:18:09, Á¶È¸ : 262

-- ORA-13249: SRID 5186 does not exist in MDSYS.CS_SRS table¿¡·¯ °ü·Ã
http://iotn.co.kr/power/zboard.php?id=9_1_bbs&no=3078
-- create user MDSYS / INSERT INTO MDSYS.CS_SRS Áö¸®Á¤º¸Ã¼°è(GIS)
http://iotn.co.kr/power/zboard.php?id=9_1_bbs&no=3145
--ORA-13203: failed to read USER_SDO_GEOM_METADATA view
http://iotn.co.kr/power/zboard.php?id=9_1_bbs&no=3079

DROP TABLE GIS PURGE;
CREATE TABLE GIS (ID NUMBER, SPATIAL SDO_GEOMETRY);
CREATE INDEX GISIDX ON GIS (SPATIAL ) INDEXTYPE IS MDSYS.SPATIAL_INDEX;

ORA-39083: Object type INDEX failed to create with 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

What Privileges to Grant to a User to Create Spatial Index in a Different Schema (¹®¼­ ID 394924.1)

DROP TABLE GIS PURGE;
CREATE TABLE GIS (ID NUMBER, SPATIAL SDO_GEOMETRY);
INSERT INTO GIS VALUES(1,SDO_GEOMETRY(2001, 5186, SDO_POINT_TYPE(184452.183, 297062.689, NULL), NULL, NULL));
COMMIT;
CREATE INDEX GISIDX ON GIS (SPATIAL ) INDEXTYPE IS MDSYS.SPATIAL_INDEX;

SQL> CREATE INDEX GISIDX ON GIS (SPATIAL ) INDEXTYPE IS MDSYS.SPATIAL_INDEX;
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

SQL> alter INDEX GISIDX rebuild;
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-29400: data cartridge error
ORA-01403: no data found
ORA-13249: internal error in Spatial index: [mdidxrbd]
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 313

-- exp ÆÄÀÏ ¿­¾î º¸¸é INDEX METADATA ´ÙÀ½¿¡
-- INSERT INTO USER_SDO_GEOM_METADATA values ...  È®ÀÎÇØ¼­ ³ÖÁÖ¸é µÇ°Ú´Ù.
-- ¹é¾÷½Ã Å×ÀÌºí ¹é¾÷ÈÄ USER_SDO_GEOM_METADATA ¿¡¼­ Å×À̺í,Ä÷³¿¡ ´ëÇÑ µ¥ÀÌÅ͵µ ¹é¾÷ Çϴ°Šº¸¸é ¼öµ¿À¸·Î
-- USER_SDO_GEOM_METADATA ³ÖÁà¾ß À妽º°¡ ¸¸µé¾î Áø´Ù.

-- ¿¹½Ã
INSERT INTO USER_SDO_GEOM_METADATA values ('GIS','SPATIAL',
mdsys.SDO_dim_array(
MDSYS.SDO_DIM_ELEMENT('X','0','193324.945','.00000005'),
MDSYS.SDO_DIM_ELEMENT('X','0','321122.043','.00000005')),'5186') ;

-- ¿¡·¯´Â ³ªµµ À妽º´Â ÀÖÀ¸´Ï rebuild ÇÏ¸é µÈ´Ù.
select 'alter index '||owner||'.'||index_name||' rebuild;' from dba_indexes where DOMIDX_OPSTATUS='FAILED';


44.192.254.173


  LIST

Á¦¸ñ ÀÛ¼ºÀÚ ÀÛ¼ºÀÏ Á¶È¸
Admin  [ °øÁö ] 😃 ¼­ºñ½º ½Ã°£ 08:00 ~ 23:00 / ¾ÈµÇ¸é ³ªÁß¿¡ ´Ù½Ã ¹æ¹® ÇØÁÖ¼¼¿ä~.😅    ÃÖ±æÈ£ 2008/11/26 113
Admin  [ ÇÊ¿ä ÇÏ½Å°Ô ÀÖÀ¸½Ã¸é ÂÊÁö ¶Ç´Â gilho.kr@gmail.com ¸ÞÀÏ ÁÖ¼¼¿ä~ ]    ÃÖ±æÈ£ 2006/07/14 134
Admin  auto compile [ dba_objects LAST_DDL_TIME DDL ½ÇÇà ]    ÃÖ±æÈ£ 2023/09/27 2
Troubleshoot  verify_queryable_inventory returned ORA-20001 / ORA-20013: DBMS_QOPATCH ran mostly in non install area    ÃÖ±æÈ£ 2023/09/25 4
Admin  trg_ddl_log / trigger ddl log /    ÃÖ±æÈ£ 2023/09/22 6
Troubleshoot  datapatch -verbose verify_queryable_inventory returned ORA-06502 / select dbms_sqlpatch.verify_queryable_inventory from dual;    ÃÖ±æÈ£ 2023/09/22 8
Troubleshoot  ORA-46258: Cleanup not initialized for the audit trail    ÃÖ±æÈ£ 2023/09/20 4
Admin  Linux 6 , Oracle 19 Error [ ./sqlplus: /lib64/libc.so.6: version `GLIBC_2.17' `GLIBC_2.14' ]    ÃÖ±æÈ£ 2023/09/15 2
Troubleshoot  oci-24550 [3762504530] [Unhandled exception: Code=e0434352 Flags=1]    ÃÖ±æÈ£ 2023/09/14 3
Script  dbstart dbstop dbstatus dbrestart HA script    ÃÖ±æÈ£ 2023/08/21 20
Install and Config  libnls12.a(lxhlang.o): undefined reference to symbol '__tls_get_addr@@GLIBC_2.3'    ÃÖ±æÈ£ 2023/08/01 10
Admin  ORA-39173: Encrypted data has been stored unencrypted in dump file set. [ dba_encrypted_columns °ü·Ã Å×ÀÌºí ¹é¾÷ ¾ÈµÊ ]    ÃÖ±æÈ£ 2023/07/26 12
Admin  19c patch EE to SE install [ ./runInstaller -silent -responseFile `pwd`/db_install.rsp ]    ÃÖ±æÈ£ 2023/07/18 15
Admin  alter table MODIFY ENCRYPT ARIA256 ARIA-256 [ AES to ARIA ] Ä÷³ ¾ÏÈ£    ÃÖ±æÈ£ 2023/07/14 17
Admin  23c    ÃÖ±æÈ£ 2023/07/12 11
Admin  ORA-39046: Metadata remap REMAP_NAME has already been specified.    ÃÖ±æÈ£ 2023/06/26 10
Install and Config  alter system set asm_diskstring RAC    ÃÖ±æÈ£ 2023/06/09 23

    ¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö 1 [2][3][4][5][6][7][8][9][10]..[149]   [´ÙÀ½ 10°³]
       

Copyright 1999-2023 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)
ÃÖ±Ù ´ñ±Û
2021/06/30
À©µµ¿ì ¼­¹ö¿¡¼­ sqlplus .... ORA-...
by ÃÖ±æÈ£
2021/06/30
ORA-28500: connection from O...
by ÃÖ±æÈ£
2019/05/02
pkg È®ÀÎ SELECT * FROM AL...
by ÃÖ±æÈ£
ÃÖ±Ù °Ô½Ã¹°
09/27
[ORACLE]
auto compile [ dba_objects LAS....
by ÃÖ±æÈ£
09/25
[ORACLE]
verify_queryable_inventory ret....
by ÃÖ±æÈ£
09/11
[¿î¿µÃ¼Á¦]
ntfy.sh / Ǫ½Ã ¾Ë¸² º¸³»±â.
by ÃÖ±æÈ£