How to export/import statistics

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;