{"id":417,"date":"2014-05-13T15:58:00","date_gmt":"2014-05-13T13:58:00","guid":{"rendered":"http:\/\/www.rocworks.at\/wordpress\/?p=417"},"modified":"2014-05-14T17:22:15","modified_gmt":"2014-05-14T15:22:15","slug":"how-to-copy-wincc-oa-rdb-manager-schema-and-data-to-another-database","status":"publish","type":"post","link":"https:\/\/www.rocworks.at\/wordpress\/?p=417","title":{"rendered":"How to copy WinCC OA RDB-Manager schema and data to another database&#8230;"},"content":{"rendered":"<p><code>\/\/ create all tablespaces<br \/>\ncreate tablespace PVSSRDB_ALERT_00100000 datafile '+PVSS';<br \/>\ncreate tablespace PVSSRDB_ALERT_00100000I datafile '+PVSS';<br \/>\ncreate tablespace PVSSRDB_EVENT10_00100003 datafile '+PVSS';<br \/>\ncreate tablespace PVSSRDB_EVENT10_00100003I datafile '+PVSS';<br \/>\ncreate tablespace PVSSRDB_EVENT_00100001 datafile '+PVSS';<br \/>\ncreate tablespace PVSSRDB_EVENT_00100001I datafile '+PVSS';<br \/>\ncreate tablespace PVSSRDB_EXTERN_00100011 datafile '+PVSS';<br \/>\ncreate tablespace PVSSRDB_VALUES_00100002 datafile '+PVSS';<br \/>\ncreate tablespace PVSSRDB_VALUES_00100002I datafile '+PVSS';<br \/>\ncreate tablespace PVSSRDB_VALUES_00100006 datafile '+PVSS';<br \/>\ncreate tablespace TS_PVSSRDB datafile '+PVSS';<\/p>\n<p>\/\/ create roles<br \/>\ncreate role R_APP_PVSSRDB;<\/p>\n<p>\/\/ create database link to old database<br \/>\ncreate database link solaris connect to system identified by manager using 'solaris\/db';<\/p>\n<p>\/\/ create directory (in 12c with pluggable database the default data_pump_dir directory does not work)<br \/>\ncreate directory data_pump as '\/app\/oracle\/admin\/CDB\/dpdump';<\/p>\n<p>\/\/ import data with database link<br \/>\nimpdp system\/manager@database\/pvss schemas=(PVSSRDB,PVSSAPP) network_link=solaris directory=data_pump parallel=2<\/p>\n<p>\/\/ grant execute on sys.dbms_lock to pvssrdb<br \/>\ngrant execute on dbms_lock to pvssrdb;<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\/\/ create all tablespaces create tablespace PVSSRDB_ALERT_00100000 datafile &#8216;+PVSS&#8217;; create tablespace PVSSRDB_ALERT_00100000I datafile &#8216;+PVSS&#8217;; create tablespace PVSSRDB_EVENT10_00100003 datafile &#8216;+PVSS&#8217;; create tablespace PVSSRDB_EVENT10_00100003I datafile &#8216;+PVSS&#8217;; create tablespace PVSSRDB_EVENT_00100001 datafile &#8216;+PVSS&#8217;; create tablespace PVSSRDB_EVENT_00100001I datafile &#8216;+PVSS&#8217;; create tablespace PVSSRDB_EXTERN_00100011 datafile &#8216;+PVSS&#8217;; create tablespace PVSSRDB_VALUES_00100002 datafile &#8216;+PVSS&#8217;; create tablespace PVSSRDB_VALUES_00100002I datafile &#8216;+PVSS&#8217;; create tablespace PVSSRDB_VALUES_00100006 datafile &#8216;+PVSS&#8217;; create &hellip; <a href=\"https:\/\/www.rocworks.at\/wordpress\/?p=417\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">How to copy WinCC OA RDB-Manager schema and data to another database&#8230;<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,3],"tags":[],"class_list":["post-417","post","type-post","status-publish","format-standard","hentry","category-oracle","category-wincc-oa"],"_links":{"self":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=417"}],"version-history":[{"count":3,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/417\/revisions"}],"predecessor-version":[{"id":421,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/417\/revisions\/421"}],"wp:attachment":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}