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### tables=lims.sample, lims.test remap_schema=lims:transfer content=data_only table_exists_action=truncate

time impdp your-name_dba directory=dmpdir logfile=exp###-test-export.log dumpfile=limsjr_full-###.dmpdp schemas=geodp### remap_schema=geodp###:geodp###_review 

Use SQL Developer to review the content of the SHIPTEST TRANSFER.NEW_SAMPLE table. Diffo Repeat for the restored copy of the GEODP### catalog.Cleanup or leave it for your counterpartGEODP###_REVIEW schema. Do not cleanup. Leave it for the oncoming crew to review.

Notify everyone that its done

...