Inserting/deleting records into/out of table
Hi,
I have 2 tables 200607msginfo and 200608msginfo. These 2 tables are joined with a MERGE table 2006msginfo.
When I start importing data into 200608msginfo (via LOAD DATA ...) the table, 200608msginfo gets locked while it is importing the data. Now I want to run a query on 2006msginfo. Does this mean that it'll run a query only once the import is finished (because the 200608msginfo table is locked) or would it only return the results of the 200607msginfo table?
What would happen if I deleted records from a table instead of removing the table from the merged table?
Thanks,
Nolan
Subject
Views
Written By
Posted
Inserting/deleting records into/out of table
11142
November 16, 2006 06:21AM
6749
November 20, 2006 08:54AM
6387
June 05, 2007 03:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.