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 -> Re: HELP - Oracle Schema Import problem

Re: HELP - Oracle Schema Import problem

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 27 Jul 2007 14:59:49 -0700
Message-ID: <1185573587.389763@bubbleator.drizzle.com>


Johne_uk wrote:
> Thanks for all the replies guys much appreciated and working on them.
>
> Just to recap that all that init.ora, tspaces, sga etc. are identical
> because they were created from identical scripts.
>
> As a further test I exported the schema from the slow db and then
> reimported the largest table into another schemas on the same db. This
> was equally slow and maybe I can assume that because it was using its
> own export dump for imorting purposes that this could remove the issue
> with possible encoding overheads.
>
> Queries seem to run just as quick on the server and schema exports are
> very quick - just the imports that are an issue.
>
> Still working on the unix config side but so far nothing bhas show up.
>
> Brgds
> John

My guess is that you are making one or more assumptions that are not valid. If you have access to the OEM Grid run the comparisons at hardware, operating system, and Oracle layers.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jul 27 2007 - 16:59:49 CDT

Original text of this message

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