| ORA-29902,ORA-13209 and ORA-06512 [message #352108] |
Mon, 06 October 2008 03:46  |
anil_mk
Messages: 146
Registered: August 2006
Location: Bangalore, India
|
Senior Member |
|
|
Hi All,
As i am using Oracle 11g and when I tried to execute the below statement
SELECT /*+ INDEX(cola_markets cola_spatial_idx) */
c.mkt_id, c.name FROM cola_markets c WHERE SDO_NN(c.shape,
SDO_geometry(2001, NULL, SDO_point_type(10,7,NULL), NULL,
NULL), 'sdo_num_res=2') = 'TRUE';
Got the error like
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13209: internal error while reading SDO_INDEX_METADATA table
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 333
And the table which is used above cola_markets has spatial index(MDSYS.SPATIAL_INDEX) on shape column.
Please suggest if anyone have idea about SPATIAL.
Thanks & Regards,
Anil MK
|
|
|
|
|
|
|
|
| Re: ORA-29902,ORA-13209 and ORA-06512 [message #390482 is a reply to message #389947] |
Fri, 06 March 2009 09:37  |
SteveSerra
Messages: 5
Registered: October 2008
Location: Nashua, NH
|
Junior Member |
|
|
Anil,
One way is to use EM cosole, this is documented in the user's guide or you can get patchsets.sh
From http://www.dbazine.com/oracle/or-articles/phelps1
Using patchsets.sh
The Oracle-provided patch-comparison utility, patchsets.sh, is a handy tool for reviewing patchset levels. Family Pack versions, fully installed products, and shared installed products, along with the latest version available, are displayed in the output. Information about the latest version of this utility can be reviewed in MetaLink Note 139684.1.
This utility is updated frequently by Oracle. Before running the script, download the current version from the following FTP site: ftp://oracle-ftp.oracle.com/apps/patchsets/PATCHSET_COMPARE_TOOL/patchsets.sh.
The instance owner can use the tool by executing the following:
patchsets.sh connect=[userid]/[password]
Here's an example:
$patchsets.sh connect=apps/apps_password
More details about the parameters available for this script can be found by using the -h parameter for online help. Figure 5-2 shows an example of the output of patchsets.sh from MetaLink Note 139684.1.
The output for the file will contain the following columns for each product group:
+ Baseline Version: Displays the version provided with the release.
+ Running Version: Displays the current version installed for each product.
+ Latest Available, Status: Displays the current version available for the product. The Status portion of the column consists of two parts: the patchset status (Rel is short for released, Sup for superseded, and Obs for obsoleted) and the distribution status (By_Metal indicates it is on MetaLink, Not_Dist means it is not available, and By_Dev means it is available from development only).
Review the output to find any products that have updates available.
thanks
Steve
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
