It sounds like you want to ensure that an external database has
the same execution plan for a query as the one you are developing
and/or testing on.
There's a little more to it than that. You must make sure you have
the proper init.ora params set, create outlines, and export the
outlines for use in another database.
Take a look at Chapter 10 'Using Plan Stability' in the 'Designing
and Tuning for Performance' manual.
Jared
On Thursday 24 May 2001 15:18, [EMAIL PROTECTED] wrote:
> Hi all,
> According to the 8i utilities manual I should be able to export a tables'
> statistics
> from one database, then import those statistics into another database.
> I have tried various combinations of export and import scripts but nothing
> seems to
> work. My table has none of the restrictions described in the utilities
> manual that
> would prevent the statistics from being exported and then imported.
> Can this export/import of statistics be done at a single table level or
> does it have
> to be a full database export? If not at the table level can it be done at
> the schema
> level?
>
> Thanks everyone,
> Gary Bonner
> [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).