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

Home -> Community -> Usenet -> c.d.o.misc -> Re: problem running export_schema_stats on different schema

Re: problem running export_schema_stats on different schema

From: M <michaelkatsilis_at_yahoo.com>
Date: 13 Nov 2004 06:47:11 -0800
Message-ID: <48691fdc.0411130647.48603c83@posting.google.com>


Ok, here is the solution...thanks to me for my help...

BEGIN
   SYS.DBMS_STATS.EXPORT_SCHEMA_STATS ('POWNER',

                                       'FULL_PROD_STATS'
                                       NULL,
                                       USER);
END;
> -- Problem occurs here...
> BEGIN
> SYS.DBMS_STATS.EXPORT_SCHEMA_STATS ('POWNER',
> 'MK.FULL_PROD_STATS');
> END;
Received on Sat Nov 13 2004 - 08:47:11 CST

Original text of this message

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