Oracle Database Discussions

I am trying to do some imp/exp between two oracle databases.
During the importing, I got an error:
IMP-00060: Warning: Skipping table "BIAPPS"."HR_LOCATIONS_ALL" because object type "MDSYS"."SDO_ORDINATE_ARRAY" does not exist or has different identifier

However, when I login my target database as sysdba and run the following scrip:
select object_name, object_type, owner from dba_objects where object_name='SDO_ORDINATE_ARRAY';

I found that object type is actually existing in my target database:
OBJECT_NAME OBJECT_TYPE OWNER
------------------------------------------------------------------------------------------
SDO_ORDINATE_ARRAY SYNONYM PUBLIC
SDO_ORDINATE_ARRAY TYPE MDSYS

I run"Grant all on sdo_ordinate_array to biapps;" and tried to import the table again but the I still got the same error information.

Could anyone tell me the reason of this problem and how to get that HR_LOCATIONS_ALL imported? Thanks a lot.



Here is the DDL of HR_LOCATIONS_ALL that I got from source database:
CREATE TABLE "BIAPPS"."HR_LOCATIONS_ALL"
+( "LOCATION_ID" NUMBER(15,0),+
+"ENTERED_BY" NUMBER(15,0),+
+"LOCATION_CODE" VARCHAR2(60 BYTE),+
+"ADDRESS_LINE_1" VARCHAR2(240 BYTE),+
+"ADDRESS_LINE_2" VARCHAR2(240 BYTE),+
+"ADDRESS_LINE_3" VARCHAR2(240 BYTE),+
+"BILL_TO_SITE_FLAG" VARCHAR2(30 BYTE),+
+"COUNTRY" VARCHAR2(60 BYTE),+
+"DESCRIPTION" VARCHAR2(240 BYTE),+
+"DESIGNATED_RECEIVER_ID" NUMBER(15,0),+
+"IN_ORGANIZATION_FLAG" VARCHAR2(30 BYTE),+
+"INACTIVE_DATE" DATE,+
+"INVENTORY_ORGANIZATION_ID" NUMBER(15,0),+
+"OFFICE_SITE_FLAG" VARCHAR2(30 BYTE),+
+"POSTAL_CODE" VARCHAR2(30 BYTE),+
+"RECEIVING_SITE_FLAG" VARCHAR2(30 BYTE),+
+"REGION_1" VARCHAR2(120 BYTE),+
+"REGION_2" VARCHAR2(120 BYTE),+
+"REGION_3" VARCHAR2(120 BYTE),+
+"SHIP_TO_LOCATION_ID" NUMBER(15,0),+
+"SHIP_TO_SITE_FLAG" VARCHAR2(30 BYTE),+
+"STYLE" VARCHAR2(7 BYTE),+
+"TAX_NAME" VARCHAR2(15 BYTE),+
+"TELEPHONE_NUMBER_1" VARCHAR2(60 BYTE),+
+"TELEPHONE_NUMBER_2" VARCHAR2(60 BYTE),+
+"TELEPHONE_NUMBER_3" VARCHAR2(60 BYTE),+
+"TOWN_OR_CITY" VARCHAR2(30 BYTE),+
+"ATTRIBUTE_CATEGORY" VARCHAR2(30 BYTE),+
+"ATTRIBUTE1" VARCHAR2(150 BYTE),+
+"ATTRIBUTE2" VARCHAR2(150 BYTE),+
+"ATTRIBUTE3" VARCHAR2(150 BYTE),+
+"ATTRIBUTE4" VARCHAR2(150 BYTE),+
+"ATTRIBUTE5" VARCHAR2(150 BYTE),+
+"ATTRIBUTE6" VARCHAR2(150 BYTE),+
+"ATTRIBUTE7" VARCHAR2(150 BYTE),+
+"ATTRIBUTE8" VARCHAR2(150 BYTE),+
+"ATTRIBUTE9" VARCHAR2(150 BYTE),+
+"ATTRIBUTE10" VARCHAR2(150 BYTE),+
+"ATTRIBUTE11" VARCHAR2(150 BYTE),+
+"ATTRIBUTE12" VARCHAR2(150 BYTE),+
+"ATTRIBUTE13" VARCHAR2(150 BYTE),+
+"ATTRIBUTE14" VARCHAR2(150 BYTE),+
+"ATTRIBUTE15" VARCHAR2(150 BYTE),+
+"ATTRIBUTE16" VARCHAR2(150 BYTE),+
+"ATTRIBUTE17" VARCHAR2(150 BYTE),+
+"ATTRIBUTE18" VARCHAR2(150 BYTE),+
+"ATTRIBUTE19" VARCHAR2(150 BYTE),+
+"ATTRIBUTE20" VARCHAR2(150 BYTE),+
+"LAST_UPDATE_DATE" DATE,+
+"LAST_UPDATED_BY" NUMBER(15,0),+
+"LAST_UPDATE_LOGIN" NUMBER(15,0),+
+"CREATED_BY" NUMBER(15,0),+
+"CREATION_DATE" DATE,+
+"OBJECT_VERSION_NUMBER" NUMBER(9,0),+
+"TP_HEADER_ID" NUMBER,+
+"ECE_TP_LOCATION_CODE" VARCHAR2(35 BYTE),+
+"GLOBAL_ATTRIBUTE_CATEGORY" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE1" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE2" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE3" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE4" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE5" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE6" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE7" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE8" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE9" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE10" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE11" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE12" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE13" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE14" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE15" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE16" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE17" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE18" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE19" VARCHAR2(150 BYTE),+
+"GLOBAL_ATTRIBUTE20" VARCHAR2(150 BYTE),+
+"BUSINESS_GROUP_ID" NUMBER(15,0),+
+"LOC_INFORMATION13" VARCHAR2(150 BYTE),+
+"LOC_INFORMATION14" VARCHAR2(150 BYTE),+
+"LOC_INFORMATION15" VARCHAR2(150 BYTE),+
+"LOC_INFORMATION16" VARCHAR2(150 BYTE),+
+"LOC_INFORMATION17" VARCHAR2(150 BYTE),+
+"LOC_INFORMATION18" VARCHAR2(150 BYTE),+
+"LOC_INFORMATION19" VARCHAR2(150 BYTE),+
+"LOC_INFORMATION20" VARCHAR2(150 BYTE),+
+"DERIVED_LOCALE" VARCHAR2(240 BYTE),+
+"GEOMETRY" "MDSYS"."SDO_GEOMETRY" ,+
+"LEGAL_ADDRESS_FLAG" VARCHAR2(30 BYTE),+
+"TIMEZONE_CODE" VARCHAR2(50 BYTE)+
+) PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS NOLOGGING+
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "BIAPPS"
VARRAY "GEOMETRY"."SDO_ELEM_INFO" STORE AS BASICFILE LOB
+(ENABLE STORAGE IN ROW CHUNK 8192+
CACHE
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
VARRAY "GEOMETRY"."SDO_ORDINATES" STORE AS BASICFILE LOB
+(ENABLE STORAGE IN ROW CHUNK 8192+
CACHE
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;