Hi all,
1]In Primary, if a table "A" is in NOLOGGING, redo's are not generated(except the dictionary stuff) if INSERT is performed with "APPEND" hint. Isn't it?
(900 rows as inserted with append hint into A)
2]So if there is a standby, while the archive logs are applied the table "A" isn't populated with the data. (isn't it ?)
3]On Primary, if i "DELETE from A where id=3",
what would happen while that particular archive log is applied on the standby(which has the table but no data 'coz of nologging and append ?
What would happen if after step2, i open the standby in read only and perform
select * from A;
Will it through error? or give "no rows selected" ?
TIA,
JJ