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