Hi,
The sql navigator version we have installed is 3.0 and by using version
5. I can do a select * also. But I just don't want to upgrade the
software just because of these columns as there are about 18 tables
having this column.
Regards,
Inder
-----Original Message-----
From: Michael Porter
[mailto:oracledba-ezmlmshield-x44264306.[Email address protected]
Sent: Friday, January 27, 2006 11:46 AM
To: LazyDBA Discussion
Subject: Re: Ora-600
Don't do a select of those columns of that data type ( they likely did a
select *) as it will fail on that data type. NO, you cannot disable and
even if you could, that would not affect columns that have a data type
that your tool does not support...
M
>>> "Inder Singh " <oracledba-ezmlmshield-x31427636.[Email address
>>> protected] 1/27/2006 11:06 AM >>>
Hi,
We have a Oracle apps database 9.2.0.5 running on hp-ux 11.11.
This morning one of the user complained about getting error 600 while
selecting from hr_locations_all table using third party tools (sql
navigator). He can select just fine if he selects specific columns
without this column
GEOMETRY MDSYS.SDO_GEOMETRY
When I looked the structure of the table It has a geometry column
defined as following:
GEOMETRY MDSYS.SDO_GEOMETRY
I looked on metalink and found that it is because of spatial installed.
Is it possible to disable spatial or how It can be avoided?
Please advise.
Regards,
Inder
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page