Re: Oracle read write while importing and loading

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Tue, 12 Apr 2005 14:55:33 GMT
Message-ID: <Xns963650A0A42B8SunnySD@68.6.19.6>

"DB2 Novice" <db2novice_at_yahoo.com> wrote in news:1113317224.942490.80170_at_o13g2000cwo.googlegroups.com:

> Hello,
>
> Is there a way users can read write when the dba is doing the importing
> (imp) and loading using SQL Loader? Will the tables be locked (either
> table or row level) while these tools are running? I know export is
> fine because there is the CONSISTENT=Y.
>

With Oracle readers do NOT block writers and writers do not block readers. Received on Tue Apr 12 2005 - 09:55:33 CDT