See Export/Import
PRO begin DBMS_STATS.CREATE_STAT_TABLE ( ownname => 'SYSTEM', stattab => 'SPRO', tblspace => 'TOOLS'); end; --schema begin DBMS_STATS.EXPORT_SCHEMA_STATS ( ownname => 'PIN', stattab => 'SPRO', statid => null, statown => 'SYSTEM'); end; --database, use SYS begin DBMS_STATS.EXPORT_DATABASE_STATS ( stattab => 'SPRO', statid => NULL, statown => 'SYSTEM'); end; |
my db begin DBMS_STATS.CREATE_STAT_TABLE ( ownname => 'ALDO', stattab => 'SPRO', tblspace => null); end; insert into spro select * from spro@to_pinpro_system |
DEV begin DBMS_STATS.CREATE_STAT_TABLE ( ownname => 'SYSTEM', stattab => 'SPRO', tblspace => 'TOOLS'); end; |
my db insert into spro@to_pinsim_system select * from spro; commit; |
DEV --schema begin DBMS_STATS.IMPORT_SCHEMA_STATS ( ownname => 'PIN', stattab => 'SPRO', statid => NULL, statown => 'SYSTEM', no_invalidate => FALSE); end; --database begin DBMS_STATS.IMPORT_DATABASE_STATS ( stattab => 'SPRO', statid => NULL, statown => 'SYSTEM', no_invalidate => FALSE); end; |