oracle oracle, May 08, 2017 - 10:31 am UTC
Hi,
I have export the production and import into the restoration server with expdp impdp and when try to compare with
SELECT COUNT(*),OBJECT_TYPE FROM DBA_OBJECTS WHERE OWNER='CPG_PROD' GROUP BY OBJECT_TYPE ORDER BY 2;
here is comparison not matching -
This names tables not imported these are the tables - MDOT_15A4F$
MDOT_15A6E$
MDOT_21574$
MDOT_2157F$
MDRT_15A44$
MDRT_15A4F$
MDRT_15A6E$
MDRT_20315$
MDRT_20C5F$
MDRT_21574$
MDRT_2157F$
and on the restoration db there is some tables which is not available on production db these tables are -
MDRT_248C7$
MDRT_248D2$
MDRT_248DC$
MDRT_248E5$
MDRT_248EF$
MDRT_248F8$
MDRT_24903$
Please let me how why these tables not imported and import logfile is succesfully no any warnings and errors. And also let me know why some different name tables are imported which are not available on production.
Thanks
May 09, 2017 - 2:10 am UTC
Ok. These are underlying objects that we needed to create to support some other part of the database. In this case, they will be for Spatial support.
The object names are automatically assigned, typically the OBJECT_ID from user_objects of the source table will be used in the automatically created objects.
Because you imported and created new objects, they have new object id's.
You can excluded these from your query by looking at the SECONDARY column in xxx_TABLES
oracle oracle, May 08, 2017 - 11:36 am UTC
I also tried as you recommended but showing an error logfile is -
cat 16MDRT_20315.log
;;;
Export: Release 11.2.0.1.0 - Production on Mon May 8 16:59:18 2017
Starting "CPG_PROD"."SYS_EXPORT_TABLE_03": cpg_prod/******** parfile=myparfile.par
ORA-39166: Object CPG_PROD.MDRT_20315$ was not found.
ORA-31655: no data or metadata objects selected for job
Job "CPG_PROD"."SYS_EXPORT_TABLE_03" completed with 2 error(s) at 16:59:25
Thanks
May 09, 2017 - 2:12 am UTC
Sorry, I should have read more carefully.
MDRT_... tables are Spatial, you dont need to import them. See the response to other followup.