How to replicate OSM 7.2 schema
edited Nov 19, 2012 12:34AM in Order and Service Management (Communications Industry) (MOSC) 1 commentAnswered
Goal
Due to new schema tables changes in OSM 7.2, traditional database Export and Import tool could not be used to export OSM 7.2 schema, this note will tell you how to use Oracle database datapump tools to replicate OSM schema
Fix
Use below steps to export OSM 7.2 schema
1. expdp osm72_source/password@tns_entry DUMPFILE=osm72_source.dmp DIRECTORY=DATA_PUMP_DIR CONTENT=DATA_ONLY LOGFILE=osm72_source_w.log
2. Exported file / log file can be found in database machine by this query
select DIRECTORY_PATH from dba_directories where DIRECTORY_NAME='DATA_PUMP_DIR';
DIRECTORY_PATH
----------------------------------------------------------
C:\oracle\admin\orcl11g\dpdump\
1