mapviewer demo Import error ( imp-00980 )
I'm encountering an import problem when attempting to import the mvdemo.dmp sample data that is included with the Mapviewer demo into Oracle 9i PEdition. Is there a problem with the the EXP coming from Oracle v8? Here is a sample of the error log output:
Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses US7ASCII character set (possible charset conversion)
export server uses US7ASCII NCHAR character set (possible ncharset conversion)
. importing SCOTT's objects into SCOTT
. . importing table "STYLES" 250 rows imported
. . importing table "THEMES" 7 rows imported
. . importing table "MAPS" 2 rows imported
. . importing table "CITIES" 195 rows imported
. . importing table "COUNTIES" 3230 rows imported
. . importing table "INTERSTATES" 239 rows imported
. . importing table "STATES" 56 rows imported
IMP-00017: following statement failed with ORACLE error 980:
"BEGIN "
"execute immediate 'INSERT INTO USER_SDO_GEOM_METADATA values (''CITIES'','"
"'LOCATION'',mdsys.SDO_dim_array(MDSYS.SDO_DIM_ELEMENT(''X'',-180,180,.00000"
"005),MDSYS.SDO_DIM_ELEMENT(''Y'',-90,90,.00000005)),NULL) ' ; "
"COMMIT; END;"
IMP-00003: ORACLE error 980 encountered
ORA-00980: synonym translation is no longer valid
ORA-06512: at line 2
IMP-00088: Problem importing metadata for index CITIES. Index creation will be skipped
I have discovered that the following view does not exist in the db:
USER_SDO_GEOM_METADATA
Help would be appreciated.
-Peter