Database Software

Hi all,

I'm trying to use datapump to transport my schema from one database to another. However i have problem with my georaster data.

MAP
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(38)
GEOR SDO_GEORASTER

MAP_RDT
Name Null? Type
----------------------------------------- -------- ----------------------------
RASTERID NOT NULL NUMBER
PYRAMIDLEVEL NOT NULL NUMBER
BANDBLOCKNUMBER NOT NULL NUMBER
ROWBLOCKNUMBER NOT NULL NUMBER
COLUMNBLOCKNUMBER NOT NULL NUMBER
BLOCKMBR MDSYS.SDO_GEOMETRY
RASTERBLOCK BLOB

SCHOOL
Name Null? Type
----------------------------------------- -------- ----------------------------
CODE NOT NULL NUMBER(38)
ENG_NAME VARCHAR2(200)
ADDRESS VARCHAR2(200)
POSTAL VARCHAR2(200)
TELEPHONE VARCHAR2(200)
FAX VARCHAR2(200)
EMAIL VARCHAR2(200)
STATUS VARCHAR2(200)
ZONE_ID NUMBER(38)
GEOM SDO_GEOMETRY
MG_ID NUMBER(38)


Other table just contain my normal data.

Export statement:
- expdp schools/** schemas=schools directory=exp_dir dumpfile=schools.dmp

Import statement:
- impdp schools/** schemas=schools directory=imp_dir dumpfile=schools.dmp
parfile=exclude.par

exclude.par content:
exclude=trigger:"like 'GRDMLTR_%'"
exclude=table:"IN('MAP','MAP_RDT')"

- impdp schools/** schemas=schools directory=imp_dir dumpfile=schools.dmp
parfile=include.par content=metadata_only

include.par content:
include=table:"IN('MAP','MAP_RDT')"

- impdp schools/** schemas=schools directory=imp_dir dumpfile=schools.dmp
parfile=include.par content=data_only

However, after my import, i did a validation on the georaster object

select sdo_geor.validategeoraster(geor) from map;

SDO_GEOR.VALIDATEGEORASTER(GEOR)
--------------------------------------------------------------------------------
13442: RDT=MAP_RDT, RID=1

There is problem in the georaster object but i don't quite understand the information that i found online.


After my import, the type of the georaster change to
MAP
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(38)
GEOR PUBLIC.SDO_GEORASTER

SCHOOL
Name Null? Type
----------------------------------------- -------- ----------------------------
CODE NOT NULL NUMBER(38)
ENG_NAME VARCHAR2(200)
ADDRESS VARCHAR2(200)
POSTAL VARCHAR2(200)
TELEPHONE VARCHAR2(200)
FAX VARCHAR2(200)
EMAIL VARCHAR2(200)
STATUS VARCHAR2(200)
ZONE_ID NUMBER(38)
GEOM PUBLIC.SDO_GEOMETRY
MG_ID NUMBER(38)

And i have problem running my application that render the georaster with a theme created on the school. The error message is as below:

In the mapviewer console
2008-07-29 16:46:26.773 ERROR cannot find entry in ALL_SDO_GEOM_METADATA table for theme: SCHOOLS_LOCATION
2008-07-29 16:46:26.773 ERROR using query:select SRID from ALL_SDO_GEOM_METADATA where TABLE_NAME=:1 and (COLUMN_NAME=:2 OR COLUMN_NAME=:3 or COLUMN_NAME=:4) and OWNER=:5
2008-07-29 16:46:26.774 ERROR Exhausted Resultset
2008-07-29 16:46:26.783 ERROR cannot find entry in USER_SDO_GEOM_METADATA table for theme: SCHOOLS_LOCATION
2008-07-29 16:46:26.784 ERROR Exhausted Resultset



I sincerely hope if anyone could provide me with some guidance. Thanks in advance =)