need clarifiaction stats transferred
Hi All,
how to identify if the statistics transferred from one schema to another are consistent ?
i used the below method to transfer stats but still i can see the last analyzed column of the tables in imported schema has the old value,
Version : 11.2.0.3
O/S: Linux
EXEC DBMS_STATS.CREATE_STAT_TABLE ( 'user2','TEST');
EXEC DBMS_STATS.EXPORT_SCHEMA_STATS ( 'user2','TEST');
export and import of table TEST from user2 to user1,
SQL> conn user1/*****
Connected.
SQL> UPDATE TEST SET c5 = 'user1';
9588918 rows updated.
SQL> commit;
Commit complete.
SQL> EXEC DBMS_STATS.IMPORT_SCHEMA_STATS ( 'user1', 'TEST' );
0