Oracle ora:29855-ora:13203 spatial

hii have a problem with the spatial index.i have the next codemy table isCREATE TABLE MBTE_BLQ_BLOCK(BL_ID NUMBER NOT NULL,BLM_ID NUMBER,BL_COORX NUMBER(10,3) NOT NULL,BL_COORY NUMBER(10,3) NOT NULL,BL_COORZ NUMBER(10,3) NOT NULL,BL_HASDATA NUMBER(1))/* función obtener geometria dado un punto*/cr ...

Oracle Err while creating Index - ORA-29855: ,ORA-20000

Got err while creating index. We moved the Table to new tablespace and drop the index. While creating index got this err. Col1 is clob datatype. SQL> CREATE INDEX kc_ctx_RAWTEXT ON RAWTEXT2 (col1)3 INDEXTYPE IS CTXSYS.CONTEXT4 PARALLEL ;CREATE INDEX KC_CTX_RAWTEXT ON RAWTEXT*ERROR at line 1:ORA-2 ...

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

I am receiving the following error from FME(safe software) when creating a spatial index. I have ruled out several of the common causes as reported in this forum because the procedure works for dataset with 300,000 rows of less but fails with the full dataset of 455,412 rows.I am using 10G 10.2.0.2. ...

Oracle Create Spatial Index Error ORA-29855

We have just upgraded from Oracle 8.1.7 to Oracle 9.2.0.2When I try to create a spatial index, I receive: CREATE INDEX UG_ZONES_FIXED_X ON UG_ZONES_GEO (ZONES_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX*ERROR at line 1:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-13249: Error ...

Oracle sde.st_geometry problem - ORA-29855 error on ODCINDEXCREATE - ORA-13200

Can anyone help solve this please?I am (a noob) trying to create a table with a spatial column of type SDE.ST_GEOMETRYThe following sequence on events leads to an error.CREATE TABLE debug_geoms ( description varchar2(1000), geometry sde.st_geometry);--INSERT INTO user_sdo_geom_metadata(TABLE_NAME,CO ...

Oracle ORA-29855 - Error creating Spatial Index using a Stored Procedure

HiI am using Oracle 10gR2 database and I have written a stored procedure to create spatial index. But when i execute this function i get the following error message. ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-13249: internal error in Spatial index: [mdidxrbd]ORA-13249: ...

Oracle ORA-29855

I have tried to create spatial index on a table with 90 000 000 rows. Please find enclosed database script and database outcome.SQL> create index "TEST"."TEST_GEOMETRY_SDO_IND"2 on "TEST"."TEST_LAYER" ("GEOMETRY")3 INDEXTYPE is MDSYS.SPATIAL_INDEX4 PARAMETERS ('5 SDO_INDX_DIMS = 26 LAYER_GTYPE = ...

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

We have an existing table with a spatial index. The index was disabled. When trying to create the index an error occured:SQL> CREATE INDEX inventar_geom_spatial2 ON inventar_geom(spatial_geom) INDEXTYPE IS MDSYS.SPATIAL_INDEX;CREATE INDEX inventar_geom_spatial*ERROR at line 1:ORA-29855: error occ ...

Oracle ORA-29855 problem with creation of a index

I'm trying to create an index but I have this problem:SQL>CREATE INDEX ITALIA_NODE_IDX ON ITALIA_NODE$(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX;CREATE INDEX ITALIA_NODE_IDX ON ITALIA_NODE$(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX*ERROR at line 1:ORA-29855: error occurred in the execution of O ...

Oracle problem creating spatial index(ora 29855) on 10g 2r

i use oracle 10g r2 and have problems by creating my index (ora 29855).The weird thing is that similar kinds of creating indices make one time problems and in the other time not ???First example - it's no problem to create this index and everything is finecreate table map_image(img_id number(5),img ...

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

Hi!!, We need your help!!!We are using Oracle 8.1.6, JBuilder 3.5, Jdk 2, in Solaris. We try to create an context index, with this sentence:stmt.execute("create index CLARIN on http1(text) indextype is ctxsys.context parameters('datastore clarin_pref filter ctxsys.NULL_FILTER section group html')"); ...

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

I am trying to setup Intermedia Locator and am trying to create the Locator index per the code below. Any ideas why I am getting the below error, and what I can do about it.Oracle8i Enterprise Edition Release 8.1.6.0.0 - ProductionWith the Partitioning optionJServer Release 8.1.6.0.0 - ProductionSQL ...

Oracle error ORA-29855:

when i try to create index ihave an error below this:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-20000: ConText error:DRG-11422: linguistic initialization failedDRG-00100: internal error, arguments : [52100],[drxf.c],[707],[gxtopen],[0]ORA-06512: at "CTXSYS.DRUE", line 1 ...

Oracle ORA-29855: ocorreu um erro na execugco da rotina ODCIINDEXCREATE

When I try to create a index for intermedia I getting the following error:create index Resume_Index on PROSPECT(Resume) indextype is ctxsys.context*ERRO na linha 1:ORA-29855: ocorreu um erro na execugco da rotina ODCIINDEXCREATEORA-20000: erro do interMedia Text:DRG-11422: houve falha na inicializag ...

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

Let me know did u find the answer to The following error occurred during the creation of an Intermedia index: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: interMedia Text error: ORA-28579: network error during callback from external procedure agent ORA-06512: at " ...

Oracle ora-29855 can not create index

My table has nine text column, and I successfully created one context index for six one of them seperately. But I fail to create other 3 index,with this error:ORA-29855: err in ODCIINDEXCREATE ORA-20000: interMedia Text err:ORA-06512: at "CTXSYS.DRUE", line 126ORA-06512: at "CTXSYS.TEXTINDEXMETHODS" ...

Oracle ORA-29855: erreur d'exicution de la routine ODCIINDEXCREATE

When i try:create index mon_index on mes_docs(text) indextype is ctxsys.context...the result is:ERREUR ` la ligne 1 :ORA-29855: erreur d'exicution de la routine ODCIINDEXCREATEORA-20000: ConText error:ORA-06520: PL/SQL : Erreur pendant le chargement de la bibliothhque externeORA-06522: Unable to loa ...

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

Currently I am working on Oracle 10g (10.2.0.4 Enterprise varsion). It is upgraded from Oracle 9i(9.2.0.6 Enterprise ). Operating system is Linux.I am facing many errors while creating a Text index on a table. While executing a procedure which drops and creates text index on table, first it raised f ...

Oracle ORA-29855 while creating spatial index

Hello, I am having trouble creating a spatial index. When I execute the following:create index la2003geoidx on polygons("GEOMETRY1")indextype is mdsys.spatial_index;I get the error ERROR at line 1:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineI've seen a few topics in this for ...

Oracle ORA-29855 - Unable to allocate shared memory

We are encountering troubles (unable to allocate shared memory) while indexes creation. We tried to increase the share_size_memory (actually 52 mb) but this had no effect on this error. The Oracle error code is ORA-29855. The database is version 8.1.7, hosted on a Linux machine (RedHat 7.2) with 512 ...

Oracle ORA-29855 error when creating large R-Tree index

I am trying to create an R-Tree spatial index on a large table (~3,000,000 rows) containing measured linear geometries. The create index fails after about 20 minutes with:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineand no other messages. I am running Oracle 8.1.7.2.1 and Spa ...

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

I execute following scripts without errorCREATE TABLE my_items (id NUMBER(10) NOT NULL,name VARCHAR2(200) NOT NULL,description VARCHAR2(4000) NOT NULL,price NUMBER(7,2) NOT NULL)/ALTER TABLE my_items ADD (CONSTRAINT my_items_pk PRIMARY KEY (id))/CREATE SEQUENCE my_items_seq;Then I populate the table ...

Oracle ORA-29855: error occured in ODCIINDEXCREATE routine

I'm trying to create a spatial index using Microstation Geographics, but I got error messages.The first error msg was ORA-29855: error occurred in ODCIINDEXCREATE routine. I think the other messages were also related to that routine. I tried to create a spatial index (using the same method) in anoth ...

Oracle ORA-29855: IMPORT ERROR - Please help

Please help me to solve this error. I am getting this error during importing a dump file.My database version is 9i(9.2.0.1.0) on Windows 2003==============. importing MHUBADMIN's objects into MHUBADMINIMP-00017: following statement failed with ORACLE error 29855:"CREATE INDEX "ORG_TEXT" ON "ORGANIZA ...

Oracle ORA-29855

I have this problem with spatial index. (table SOUNDING with 82 million records)(Oracle 10.2g)Here's my command:create index SIDX_SOUNDING_SHAPE on SOUNDING(SHAPE)indextype is MDSYS.SPATIAL_INDEX;Here's the errors:create index SIDX_SOUNDING_SHAPE on SOUNDING(SHAPE)*ERROR at line 1:ORA-29855: error o ...

Oracle job failed,ORA-29855: error occurred in the execution of ODCIINDEXCREATE

In my 10gR2 Linux Box,One of the job is failing,Part of this job is dropping a particular table and recreating it,then creating the Index.But I am getting the error likeORA-29855: error occurred in the execution of ODCIINDEXCREATE routineBut the same job is succesfully dropping ,recreating another t ...

Oracle ORA-29855 and ORA-38500 trying to run DBMS_RLMGR.CREATE_RULE_CLASS

SR 6892323.993.IHAC who hit this error and whatever we try it does not seem to help.In OSS DBA we are also labouring under a great ignorance of EXFIL and RLMGR.I summarised the problem for ARE and that summary follows:=======ARE REVIEW REQUEST==================BEGINDBMS_RLMGR.CREATE_RULE_CLASS (rule ...

Oracle Domain index created with error ORA-29855

10:33:54 SQL> drop index G8D_TEXT_QUERY_IDX;10:34:00 SQL> select index_name,table_name,index_type,status from user_indexes where table_name='MV_G8D_TEXT_QUERY_DATA';no rows selectedElapsed: 00:00:00.3610:34:02 SQL>10:34:32 SQL> CREATE INDEX G8D_TEXT_QUERY_IDX ON MV_G8D_TEXT_QUERY_DATA(CO ...

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

Currently I am working on Oracle 10g (10.2.0.4 Enterprise varsion). It is upgraded from Oracle 9i(9.2.0.6 Enterprise ). Operating system is Linux. I am facing many errors while creating a Text index on a table. While executing a procedure which drops and creates text index on table, first it raised ...

Oracle Dump -> ORA-29855 : routine ODCIINDEXCREATE

I have exported a dump :export ORACLE_SID=appexp userid=user/userPass owner=user file=export.dmp log=export.log statistics=none direct=YI send the dump to someone else and he find this error :IMP-00017: Echec de l'instruction suivante avec erreur ORACLE 29855 :"CREATE INDEX "SPACIAL_COORD_POSITION_F ...

Oracle ORA-13033 ORA-06512 at 11.1.0.7

I have a single shape that seems to cause ORA-13033 at 11.1.0.7 but not at 11.1.0.6. Wondering if I am missing something stupid, or if anyone else has seen this problem. I did a quick search of the posts, but didn't find anything. It could also be that spatial has a problem on the 11.1.0.7 server... ...

-2147217873 ora-01110 ora-01578

i have the the following err msg while updating a remote database..-2147217873 ....ora-01110...ora-01578..from the oracel err msg, it seems the block is corruptted..not really understand wat is this...i am using VB6 ADODB recordset with .Addnew and .update to create a new record.... ...

Ora-01034/ora-27101

I'm getting these two Oracle Error messages while I try to login to sqlplus using any login. I've tried all the steps from this thread:Ora-01034 / Ora-27101except when I got to this point:SET ORACLE_SID=ilnksqlplus /nologconn sys/change_on_install as sysdbastartupI received an error 'ORA-01031: insu ...

Oracle ORA-29902 / ORA-01455 on thesaurus search

i have a problem with the intermedia thesaurs search.When i use a thesaurus function in my querySELECT rowid FROM wag_vlb_storage WHERE CONTAINS(xml, 'pt( Kinder) within title') > 0 AND storage_type='PRD'an oracle error ORA-29902 / ORA-01455 occurs.My thesaurus have 470.000 term (TT) (2.5 Mill al ...

Oracle ORA-29902 / ORA-01455 on thesaurus search

repost Hi, i have a problem with the intermedia thesaurs search. When i use a thesaurus function in my query SELECT rowid FROM wag_vlb_storage WHERE CONTAINS(xml, 'pt( Kinder) within title') > 0 AND storage_type='PRD' an oracle error ORA-29902 / ORA-01455 occurs. My thesaurus have 470.000 term (T ...

Oracle ORA-29902 / ORA-01455 on thesaurus search

repost - anybody from the intermedia team out there ??? Hi, i have a problem with the intermedia thesaurs search. When i use a thesaurus function in my query SELECT rowid FROM wag_vlb_storage WHERE CONTAINS(xml, 'pt( Kinder) within title') > 0 AND storage_type='PRD' an oracle error ORA-29902 / OR ...

Oracle Why there are 2 tnsnames.ora & listener.ora files ?

According to the installation guide, I have TNS_ADMIN=/opt/oracle/config/9.2.0; export TNS_ADMINin the .profile at home directory of user "oracle"After installation succeeded, I found that there are two places that have tnsnames.ora & listener.oraOne is at /opt/oracle/config/9.2.0Other one is at ...

Oracle SQL Loader and Error ORA-01847/ORA-01839

While using the direct loading in SQL-LOADER when we get the ORA-01847/ORA-01839 all the other records are getting errorred out. It goes fine with the conventional loading. Should I use some parameters or anything to make sure that all the other records are not rejected when we get the ORA-01847/ORA ...

Oracle return ORA-02019,ORA-02063 during update view base on DB Link

I created simple application base on view. When I try to update something I get ORA-02019,ORA-02063. Same update from SqlPlus works as expected. Help me, Stanislav. ...

Oracle ORA-01652, ORA-27056, OSD-04005, O/S Error

I'm using the following querySELECT O.TRAIN_NO_C, O.OUT_DATE_D, OD.COACH_NO_C, C.CLASS_CODE_C, C.AC_NAC_TYPE_C, R.LAST_DEALT_DATE_D FROM MECD_PF_OUTTRN_T O, MECD_PF_OUTTRN_DTL2_T OD, MECD_PL_RS19_DTL1_T R, MECD_COACH_M C, MECD_TRAIN_M T WHERE O.TRAIN_NO_C = T.OUT_TRAIN_NO_C AND O.OUT_DATE_D + T.INTD ...

Oracle ORA-01034 & ORA-27101

I have oracle running on Redhat linux. It was working fine previously and I had to change the IP address to roll it into production.I have changed tnsnames.ora, listener.ora, snmp_ro.ora and sqlnet.ora files to new IP address.Now, I get ORA-01034 error, saying that Oracle is not available. And somet ...

Oracle UTL_FILE error? - ORA-20001: ORA-0000: normal, successful completion

I wrote a procedure and am getting the following error message about 20 minutes into the processing:*ERROR at line 1:ORA-20001: ORA-0000: normal, successful completionORA-06512: at "APPHARRIS.P_HARRIS_BULK_COLLECT", line 502ORA-06512: at line 1I have a fairly large amount of data that gets processed ...

Oracle Error Messages : ORA - 37118, ORA - 06512

When i'm starting the oracle workspace manager software and trying to create a new workspace related to a schema, after to be connected to a database instance,I get those error messages: ora - 37118, ora - 06512 ...

Oracle where should i keep listener.ora, tnsnames.ora files in 10g R2 RAC ?

Created 3 separate homes for Oracle CRS, Oracle ASM and Oracle instance1 under Oracle 10g R2 RAC setup. where should i keep listener.ora, tnsnames.ora & init.ora files? should i keep them in ASM home or Oracle instance1 home directory? ...

Oracle 10g I don't have the files listener.ora, tnsnames.ora and sql.ora

I uninstalled my Oracle 10g and when I re installed I got success, but when I went to the folder \network\admin didn't have the files listener.ora, tnsnames.ora and sql.ora. I have been trying during more than one month start my listener only because I need access the Oracle database from my Java ap ...

Oracle urgent ora -00353 ora-354 ora-312 errors

we are getting following errors on one of our databasei found the following on metalink to resolve TIP: Click help for a detailed explanation of this page. Bookmark Go to End Subject: Ora-354 Ora-353 And Ora-312 Reported On Mirrored Redo Log Files Doc ID: Note:332672.1 Type: PROBLEM Last Revision Da ...

Oracle ERROR: ORA-20999: ORA--20999 Error Number Not Defined

I'm not sure if it ok to post this error message here, let me know. I've searched Google and didn't find anything...My company is migrating data from one old version of Oralce (8.1.7.2) to Oracle Version 9.2.0.6.The database is basically personal information and when we migrated a record over to the ...

Oracle Error in MRU: row= 0, ORA-20001: ORA-20001: Current version of data

I have this error again - and really don't know where to begin looking for the answer.I find it very worrying that this error is generated by the internals of Apex which I cannot see. There is no indication as to why / what causes this in a general sense. Could someone explain in english / pseudo co ...

Oracle ora-01034 , ora-27101 - help!

hi, we are using 9i database it was normally working but today when attemp to make a connection gives errors ora-01034 , ora-27101 and srv4 error 2: no such file or directory cannot restart cannot shutdown , cheched the sid its ok, the value is correct (i checked case sensitiveness ) the db is on so ...

Oracle ORA-01122, ORA-01110 and ORA-01251

When we are opening the database following errors are coming in sequence as follows:ORA-01122, ORA-01110 and ORA-01251Other facts:We don’t have any backup.Database is not in archive mode.Personally I don't see any hope.What you guys think? ...