Re: create table as select block my insert
Hi Rick
let me explain.
my replication used for data analysis , which means that analysts select data from it and create tables on different database than the master is updating.
in this case when the analyst is doing CREATE TABLE...SELECT then it select a table from the main database but create table on its own database. no write permissions on the Master database.
Slave> CREATE TABLE...SELECT from X
Master> INSERT INTO X
Slave> INSERT INTO X (the replication thread run this)
...lock...(on the slave)
you can reproduce this scenario on a single DB with no replication
S1> CREATE TABLE Y AS SELECT * FROM X
S2> INSERT INTO X => ...lock...
Subject
Views
Written By
Posted
2468
October 05, 2014 03:25PM
1198
October 06, 2014 12:43PM
Re: create table as select block my insert
1439
October 06, 2014 02:28PM
1243
October 07, 2014 04:08PM
983
November 05, 2014 09:59AM
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.