HI
i'm currently integrating oracle map viewer to apex and i'm following the doc http://www.fischer-wasels.de/oracle/maps/Oracle_Maps_in_APEX_WP_US.pdf
please suggest if there is any other doc mapviewer and apex integration
while i'm importing dump file to database i'm getting errors
;;;
Import: Release 11.2.0.1.0 - Production on Tue Jul 29 00:30:00 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
Master table "MVDEMO2"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "MVDEMO2"."SYS_IMPORT_FULL_01": mvdemo2/******** directory=mvdemo_dataset dumpfile=mvdemo_naturalearth.dmp parfile=exclude.par full=y logfile=Sample_import_log.log
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39117: Type needed to create table is not included in this operation. Failing sql is:
CREATE TABLE "MVDEMO2"."WORLD_RASTER" ("GEORID" NUMBER, "GEORASTER" "MDSYS"."SDO_GEORASTER" ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" XMLTYPE COLUMN
"GEORASTER"."METADATA" STORE AS SECUREFILE BIN
ORA-39117: Type needed to create table is not included in this operation. Failing sql is:
CREATE TABLE "MVDEMO2"."RDT_NEDATA_RASTER" OF "MDSYS"."SDO_RASTER" OID 'FA9FD0091151653AE043AF0F890ADDC5' OIDINDEX ( PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576
MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ) PCTFREE 10 PCTUSED 40 INITRANS
1 MAXTRANS 255 NOCOMPRESS LOGGING
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "MVDEMO2"."ROADS_NORTH_AMERICA_PRIMARY" 84.23 MB 49183 rows
. . imported "MVDEMO2"."ROADS" 32.97 MB 56901 rows
. . imported "MVDEMO2"."STATES_PROVINCES" 25.48 MB 3670 rows
. . imported "MVDEMO2"."COUNTIES_32775_MOVED" 5.468 MB 3129 rows
. . imported "MVDEMO2"."CHILD_MORTALITY" 11.55 MB 236 rows
. . imported "MVDEMO2"."COUNTRIES" 10.52 MB 255 rows
. . imported "MVDEMO2"."COUNTIES" 3.812 MB 3230 rows
. . imported "MVDEMO2"."INTERSTATES" 3.260 MB 239 rows
. . imported "MVDEMO2"."CITIES" 3.135 MB 7322 rows
. . imported "MVDEMO2"."STATES_32775_MOVED" 1008. KB 51 rows
. . imported "MVDEMO2"."SYS_EXPORT_SCHEMA_01" 1.456 MB 1285 rows
. . imported "MVDEMO2"."STATES" 760.2 KB 56 rows
. . imported "MVDEMO2"."STYLES" 339.4 KB 358 rows
. . imported "MVDEMO2"."CUSTOMERS" 49.74 KB 205 rows
. . imported "MVDEMO2"."STATE_COUNTY_STYLES" 17.32 KB 11 rows
. . imported "MVDEMO2"."TERRITORIES" 90.33 KB 9 rows
. . imported "MVDEMO2"."CITIES_US" 19.80 KB 195 rows
. . imported "MVDEMO2"."ORIENTED_POINTS" 10.38 KB 4 rows
. . imported "MVDEMO2"."TERR_COUNTIES" 96.57 KB 3230 rows
. . imported "MVDEMO2"."THEMES" 45.67 KB 65 rows
. . imported "MVDEMO2"."TILELAYERS" 32.52 KB 4 rows
. . imported "MVDEMO2"."BASEMAPS" 16.37 KB 4 rows
. . imported "MVDEMO2"."STATE_COUNTY_THEMES" 8.539 KB 2 rows
. . imported "MVDEMO2"."EMPLOYEES" 5.656 KB 14 rows
. . imported "MVDEMO2"."TERRITORIES_TMP" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39112: Dependent object type CONSTRAINT:"MVDEMO2"."SYS_C0067488" skipped, base object type TABLE:"MVDEMO2"."RDT_NEDATA_RASTER" creation failed
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"MVDEMO2"."WORLD_RASTER" creation failed
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39112: Dependent object type INDEX:"MVDEMO2"."WORLD_RASTER_SIDX" skipped, base object type TABLE:"MVDEMO2"."WORLD_RASTER" creation failed
Job "MVDEMO2"."SYS_IMPORT_FULL_01" completed with 5 error(s) at 00:30:32
please suggest on this error
why i'm getting this error while importing the dump file
i think while importing the dump file these tables should be created automatically
i have given all the necessary permissions to the user and directory
i tried manually creating the table using the sql query but getting errors
SQL> CREATE TABLE "MVDEMO2"."WORLD_RASTER" ("GEORID" NUMBER, "GEORASTER" "MDSYS"."SDO_GEORASTER" ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" XMLTYPE COLUMN "GEORASTER"."METADATA" STORE AS SECUREFILE BIN;
CREATE TABLE "MVDEMO2"."WORLD_RASTER" ("GEORID" NUMBER, "GEORASTER" "MDSYS"."SDO_GEORASTER" ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" XMLTYPE COLUMN "GEORASTER"."METADATA" STORE AS SECUREFILE BIN
*
ERROR at line 1:
ORA-19001: Invalid storage option specified
please suggest
thanks