title: Oracle copy data between databases honoring relationships
body: <p>I have a question regarding the oracle copy command:
    Is it possible to copy data between databases (were the structure is the same) and honor relationships in one go without(!) writing procedures?</p>
  
  <p>To be more precise:
    Table B refers (by B.FK) to table A (A.PK) by a foreign key (B.FK -> A.PK; no relationship information is stored in the db itself). The keys are generated by a sequence, which is used to create the PK for all tables. </p>
  
  <p>So how to copy table A and B while keeping the relationship intact and use the target DBs sequence to generate new primary keys for the copied data (i cannot use the "original" PK values as they might already be used in the same table for a different dataset)?</p>
  
  <p>I doubt that the copy command is capable to handle this situation but what is the way to achieve the desired behavior?</p>
  
  <p>Thanks
  Matthias</p>