A reader, June 02, 2023 - 2:28 pm UTC
Great, thanx. I'll look into DataPump and CTAS.
On the second question, Yes, I meant deferred. So a problem would occur if I did something stupid, in a stored procedure, like where I insert the child first, then try to do stuff, within the current transaction, before actually adding the parent, correct?
June 07, 2023 - 7:24 am UTC
Well., not really a "problem" because its all in the one transaction.
Of course, if you did something like:
- set deferred
- insert child
- now do a query which joins parent and child (assuming that if there's a child there MUST be a parent)
then the join would fail because you haven't inserted the parent yet. But that is still only within your transaction. No-one else can see either row.
A reader, June 07, 2023 - 2:44 pm UTC