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: import and QS_CS.QS_CS_ORDER_STATUS_QT

Re: import and QS_CS.QS_CS_ORDER_STATUS_QT

From: dorit <maromdo_at_yahoo.ca>
Date: 11 Sep 2006 13:43:56 -0700
Message-ID: <1158007436.223685.99050@h48g2000cwc.googlegroups.com>

it's a new database. no one is working on this server so it's not user running something while i'm importing ...

as far as i can tell qs_cs is Customer Service Shipping schema... i'm not sure i need this schema .... (is this like example schema that comes with default database installtion ? )

dorit

fitzjarrell_at_cox.net wrote:
> dorit wrote:
> > hello.
> >
> > i'm running big import and i see another session running selects on
> > QS_CS.QS_CS_ORDER_STATUS_QT.
> >
> > can i , should i and how do i stop this process from running while i'm
> > running the import?
> >
> > thanks!
> >
> > dorit
>
> Is this table one of the currently imported objects? Obviously if it
> is, and the end user is actually seeing results, the import process for
> that table has completed and it shouldn't matter. Unless that query is
> consuming more resources than imp at which point it would affect how
> long the import process requires. Simple selects against a table
> should not be a problem, even during an import. Inserts, updates
> and/or deletes, however, ARE a problem, as referential integrity
> constraints have yet to be enabled (that doesn't happen until near the
> end of the import) and orphan records can be created.
>
> You really need to describe in better detail what, exactly, you're
> seeing while this import progresses, and what part this
> QS_CS.QS_CS_ORDER_STATUS_QT table plays in the entire process. You've
> provided very little information with which to work.
>
>
> David Fitzjarrell
Received on Mon Sep 11 2006 - 15:43:56 CDT

Original text of this message

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