Re: import and QS_CS.QS_CS_ORDER_STATUS_QT

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 - 14:13:56 CDT