Schema import and user_sdo_geom_metadata view
Dear community,
Is there a 'Best practice' notice which explains how to do a full schema import along with any spatial information that may be in user_sdo_geom_metadata view. I think this view is owned by MDSYS.
I am doing a full datapump export as SYS from DB1 , then as SYS, importing one complete schema (SCHEMA_A) into DB2. But any columns with spatial data are failing to create the spatial index.
I generally drop and re-create the user SCHEMA_A in DB2 before doing the schema import.
Database are both 11g R2 on linux platforms.
Any help gratefully received.
Is there a 'Best practice' notice which explains how to do a full schema import along with any spatial information that may be in user_sdo_geom_metadata view. I think this view is owned by MDSYS.
I am doing a full datapump export as SYS from DB1 , then as SYS, importing one complete schema (SCHEMA_A) into DB2. But any columns with spatial data are failing to create the spatial index.
I generally drop and re-create the user SCHEMA_A in DB2 before doing the schema import.
Database are both 11g R2 on linux platforms.
Any help gratefully received.
0