Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
ssh oracle@k1.ship.iodp.tamu.edu

. oraenv
ORACLE_SID = [oracle] ? SHIPTEST
[oracle]$

time impdp your-name_dba directory=dmpdir logfile=exp###-test-export.log dumpfile=limsjr_full-###.dmpdp schemas=geodp### remapschema=geodp###:geodp###_review tables=lims.sample remapschemas, lims.test remap_schema=lims:transfer remaptables=.. schemas=geodp### remap_schema=geodp###:geodp###_review

Use SQL Developer to review the content of the SHIPTEST TRANSFER.NEW_SAMPLE table. Diffo for the restored copy of the GEODP### catalog.

Cleanup or leave it for your counterpart.

Notify everyone that its done

...