Oracle Illustrated

Sep 16 2010   2:04AM GMT

Import Stats from one DB to another – Quick way

Lakshmi Venkatesh Profile: Lakshmi Venkatesh

 

 

 

Database 1- 

exec

 

 

 

 

 

 

 

 dbms_stats.create_stat_table(ownname => <DBNMAME>, stattab => ‘STATS’);

exec dbms_stats.export_table_stats(<DBNAME>,‘<table name>’,null,’STATS’,null,true,null);

Database 2-

CREATE TABLE STATS AS SELECT * FROM STATS@<DBNAME>; 

 

exec

 

 

 

 

 

 

 

dbms_stats.import_table_stats <DBAME2>,‘<table name>’,null,‘STATS’,null,true,<DBNAME2>);

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: