Skip to content

Instantly share code, notes, and snippets.

@dotmaik1

dotmaik1/datapump: import tables only.sql

Created October 6, 2016 17:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dotmaik1/20c456305671e6d27551e83c42d4b6a5 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dotmaik1/20c456305671e6d27551e83c42d4b6a5 to your computer and use it in GitHub Desktop.
Download ZIP
import tables only with datapump
Raw
datapump: import tables only.sql
nohup impdp USERID=\'/ as sysdba\' TABLES = AMOSSERVER_TRAINING2.MENU_USER, AMOSSERVER_TRAINING2.NG_USER_ACCESS, AMOSSERVER_TRAINING2.SIGN, AMOSSERVER_TRAINING2.STAFF_ACCESS_RIGHT, AMOSSERVER_TRAINING2.USER_ACCESS, AMOSSERVER_TRAINING2.USER_GROUP remap_schema=AMOSSERVER_TRAINING2:AMOSSERVER_TRAINING6, AMOSUSER_TRAINING2:AMOSUSER_TRAINING6 REMAP_TABLESPACE=TRAINING2:TRAINING6 DIRECTORY=BACKUP dumpfile=export_TRAINING2_18072016.dmp LOGFILE=import_only_tables_TRAINING2_18072016.log CONTENT=DATA_ONLY &
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment