Copy tables

[Andrzejek]

Sometimes we ask our DBA to copy data from production environment into test. After DBA truncates all the tables in test, he does his ‘magic’ of copying data from production. But, of course, tables have FK (foreign keys) and need to have data in ‘look-up’ tables first where the PK (primary key) is.

So question: is there a way (for DBA) to find all tables without FK? (so he can copy these tables first.)


Have fun.

---- Andy

 

[SantaMufasa]

Andy,

Why not use Oracle DataPump Export and Import for accomplishing your need? DataPump keeps straight all of the PKs and FKs so no user-supplied "magic" needs to occur.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.

 

[Andrzejek]

Thanks Dave,
I don’t really know what do they use to copy data. I talked to one of the DBA and the PK and FK in tables seam to be an issue, that’s why my question.
I’ll check with them what they use to copy.


Have fun.

---- Andy

 

[SantaMufasa]

BTW, Andy, if your DBAs don't use Oracle DataPump simply because they don't know how, then we can help them overcome that issue (in a kindly fashion, without embarrassment).

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.