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

Home -> Community -> Usenet -> c.d.o.server -> Exporting and Importing Statistics

Exporting and Importing Statistics

From: Myron Wintonyk <Myron.Wintonyk_at_UAlberta.ca>
Date: Sat, 24 Mar 2001 16:48:54 +1000
Message-ID: <99hg4t$k$1@kraken.itc.gu.edu.au>

I'm trying to import statistics from one db into another. However, the documentation is rather vauge in this area. I can't get it to work. Here's what I've tried:

    exp ... STATISTICS = NONE
    imp ... RECALCULATE_STATISTICS=Y ANALYZE=N

Given that I was desperate, I tried every combination of these paraeters as well.
STATISTICS=(COMPUTE,NONE) I didn't try ESTIMATE. RECALCULATE_STATISTICS=(Y,N)
ANALYZE=(Y,N) Has anyone done this successfully and can give me a hint?

Thanks ... Received on Sat Mar 24 2001 - 00:48:54 CST

Original text of this message

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