Hi Rene,
> -----Original Message-----
> From: Renewest
> I'm trying to add a new featuretype based on an Oracle
> table in 1.5.3. This worked fine in 1.5.2 but
> now, when I try to generate the bounding box, I get the message:
>
> The FeatureType 'NGG_OBJECT' has a NULL extent.
> HINT: the dataset is empty or has no default geometry attribute.
>
> The table has a spatial index, and contains data a mix of
> points and polygons.
>
> For another table that holds a mix of points and and line
> geometries there is no problem creating a featuretype.
First, check that you have the appropriate database permissions to
access the table. I've had problems in the past trying to use a
read-only user that wasn't set up properly (check that you get the same
error by connecting using a super-user's credentials).
Second, check that the metadata record is set up properly.
SELCT * FROM ALL_SDO_GEOM_METADATA where table_name = 'MY_TABLE';
Third, check that there are no errors in your geometry:
SELECT A.GID, SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(A.GEOMETRY,
M.diminfo) AS PROBLEM
FROM MY_TABLE_A,USER_SDO_GEOM_METADATA M
WHERE M.table_name = 'MY_TABLE'
AND M.column_name = 'GEOMETRY'
AND SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(A.GEOMETRY, M.diminfo) <>
'TRUE'
It should return no rows if everything's ok.
Most commonly it's the user permission problem. If neither of the above,
double check your spatial index and also check that the table has a
primary key defined.
Hope this helps,
Miles
___________________________________________________________________________
Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you are not the
intended recipient, you are notified that use or dissemination of this communication is
strictly prohibited by Commonwealth law. If you have received this transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and
DELETE the message.
Visit our web site at http://www.antarctica.gov.au/
___________________________________________________________________________