INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Copy tables

Copy tables

(OP)
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

RE: Copy tables

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.

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

RE: Copy tables

(OP)
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

RE: Copy tables

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).

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close