Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> exporting / importing Object Stats?

exporting / importing Object Stats?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Thu, 13 Oct 2005 21:13:17 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF302010677C@BLRKECMSG11.ad.infosys.com>

A basic Qs

After exporting a Table's "statistics" & will it's import into another Database containing the Same Table name & field Structure but Different Object ID be successful?

e.g. When using following command for EMP Table

Dbms_stats.IMPORT_TABLE_STATS('TBAADM','EMP',STATTAB=>'SAVESTATS',STATOW N=>'TBAADM',CASCADE=>TRUE); Thanks

Received on Thu Oct 13 2005 - 10:49:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US