[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / êꪤҳàõªòàõªÎÒ¿Ö˪˪·ª¿ð¨ÏÐñ«ëùìíÜâÏÚªÎ?ð¤àõªòÍëãÒªËìãªá¡¢Þóñªª·ªÊª±ªìªÐªÊªéªÊª¤. ]

»ç¿ëÀÚ

ID:
PW:

INDEX
01.°Ô½ÃÆÇ
°Ô½ÃÆÇ [72]
02.File Book
File ÀÚ·á½Ç [96]
Site Link [14]
°³ÀÎÆú´õ [201]
03.Field Book
Altibase [19]
Tibero [31]
MS-SQL [32]
MySQL [47]
DB2 [79]
ORACLE [3206]
PSQL [143]
CUBRID [5]
±âŸÁ¤º¸ [194]
¿î¿µÃ¼Á¦ [634]
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, Á¶È¸ : 14,265

-- 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';


216.73.216.200


  LIST

Á¦¸ñ ÀÛ¼ºÀÚ ÀÛ¼ºÀÏ Á¶È¸
Admin  [ °øÁö ] 😃 ================ ÇÊ¿ä ÇÒ¶§¸¸ ¿î¿µ ÇÕ´Ï´Ù. ¾ÈµÇ¸é ³ªÁß¿¡ ´Ù½Ã ¹æ¹® ÇØÁÖ¼¼¿ä~. =================== 😅    ÃÖ±æÈ£ 2008/11/26 116
Admin  [ ÇÊ¿ä ÇÏ½Å°Ô ÀÖÀ¸½Ã¸é ÂÊÁö ¶Ç´Â gilho.kr@gmail.com ¸ÞÀÏ ÁÖ¼¼¿ä~ ]    ÃÖ±æÈ£ 2006/07/14 136
Admin  create type ORA-39083 ORA-02304    ÃÖ±æÈ£ 2025/07/03 0
Script  sms recovery check ORA-00278 Á¤»ó º¹±¸Áß.    ÃÖ±æÈ£ 2025/07/03 0
Admin  ORA-02019: connection description for remote database not found    ÃÖ±æÈ£ 2025/07/03 0
Admin  The clock on host node2 differs from mean cluster time by    ÃÖ±æÈ£ 2025/06/27 10
Admin  PRCD-1229 ORA-29701: unable to connect to Cluster Synchronization Service [ 19c grid - 12c SE2 rac ]    ÃÖ±æÈ£ 2025/06/26 5
Admin  opatch lsinventory [ LsInventorySession failed: Array index out of range: 0 ]    ÃÖ±æÈ£ 2025/06/26 3
Admin  Linux 9 oracle 12.2 install [ /usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a ] [ linux 7, 8¿¡¼­ ¼³Ä¡ÈÄ »ç¿ëÀº °¡´É ]    ÃÖ±æÈ£ 2025/06/26 2
Admin  windows sqlplus "/as sysdba" ORA-01031: insufficient privileges    ÃÖ±æÈ£ 2025/06/16 6
Admin  ORA-00800: soft external error, arguments: [Set Priority Failed]    ÃÖ±æÈ£ 2025/06/12 9
Admin  grep /usr/bin/make $ORACLE_HOME/install/make.log [ EE / SE2 ]    ÃÖ±æÈ£ 2025/06/09 18
Admin  acfs asmcmd volcreate / srvctl add filesystem / acfsutil size / srvctl start filesystem    ÃÖ±æÈ£ 2025/06/05 15
Admin  CRS-2643 PRCD-1302 PRCD-2088 PRKF-1125 PRKF-1241    ÃÖ±æÈ£ 2025/06/04 10
Admin  HA web control    ÃÖ±æÈ£ 2025/06/02 30

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

Copyright 1999-2025 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 ÃÖ±æÈ£
ÃÖ±Ù °Ô½Ã¹°
07/03
[ORACLE]
create type ORA-39083 ORA-0230....
by ÃÖ±æÈ£
07/03
[ORACLE]
sms recovery check ORA-00278 ....
by ÃÖ±æÈ£
07/02
[¿î¿µÃ¼Á¦]
rsync -auv.
by ÃÖ±æÈ£