How to Import Table in oracle using IMPDP-brtools
Login as orasid user and open Brtools : entering command brtools.
ora<sid> 34> brtools
BR0651I BRTOOLS 7.20 (31)
BR0280I BRTOOLS time stamp: 2015-05-12 03.35.46
BR0656I Choice menu 1 – please make a selection
——————————————————————————-
BR*Tools main menu
1 = Instance management
2 – Space management
3 – Segment management
4 – Backup and database copy
5 – Restore and recovery
6 – Check and verification
7 – Database statistics
8 – Additional functions
9 – Exit program
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2015-05-12 03.35.48
BR0663I Your choice: ‘3’
BR0280I BRTOOLS time stamp: 2015-05-12 03.35.48
BR0656I Choice menu 7 – please make a selection
——————————————————————————-
Database segment management
1 = Reorganize tables
2 – Rebuild indexes
3 – Export tables
4 – Import tables
5 – Alter tables
6 – Alter indexes
7 – Additional segment functions
8 – Reset program status
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
4
BR0280I BRTOOLS time stamp: 2015-05-12 03.35.50
BR0663I Your choice: ‘4’
BR0280I BRTOOLS time stamp: 2015-05-12 03.35.50
BR0657I Input menu 94 – please enter/check input values
——————————————————————————-
BRSPACE options for import tables
1 – BRSPACE profile (profile) …………… [init<SID>.sap]
2 – Database user/password (user) ……….. [/]
3 ~ BRSPACE export run / dump file (export) . []
4 ~ Import type (type) …………………. []
5 ~ Table owner (owner) ………………… []
6 ~ Table names (tables) ……………….. []
7 – Confirmation mode (confirm) …………. [yes]
8 – Extended output (output) ……………. [no]
9 – Scrolling line count (scroll) ……….. [20]
10 – Message language (language) …………. [E]
11 – BRSPACE command line (command) ………. [-p init<SID>.sap -s 20 -l E -f tbimport]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2015-05-12 03.35.53
BR0663I Your choice: ‘3’
BR0681I Enter string value for “export” []:
/oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp
BR0280I BRTOOLS time stamp: 2015-05-12 03.35.59
BR0683I New value for “export”: ‘/oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp’
BR0280I BRTOOLS time stamp: 2015-05-12 03.35.59
BR0657I Input menu 94 – please enter/check input values
——————————————————————————-
BRSPACE options for import tables
1 – BRSPACE profile (profile) …………… [init<SID>.sap]
2 – Database user/password (user) ……….. [/]
3 ~ BRSPACE export run / dump file (export) . [/oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp]
4 ~ Import type (type) …………………. []
5 ~ Table owner (owner) ………………… []
6 ~ Table names (tables) ……………….. []
7 – Confirmation mode (confirm) …………. [yes]
8 – Extended output (output) ……………. [no]
9 – Scrolling line count (scroll) ……….. [20]
10 – Message language (language) …………. [E]
11 – BRSPACE command line (command) ………. [-p init<SID>.sap -s 20 -l E -f tbimport -x /oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
4
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.03
BR0663I Your choice: ‘4’
BR0681I Enter string value for “type” (full|tables|indexfile|show|sqlfile) []:
tables
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.09
BR0683I New value for “type”: ‘tables’
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.09
BR0657I Input menu 94 – please enter/check input values
——————————————————————————-
BRSPACE options for import tables
1 – BRSPACE profile (profile) …………… [init<SID>.sap]
2 – Database user/password (user) ……….. [/]
3 ~ BRSPACE export run / dump file (export) . [/oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp]
4 ~ Import type (type) …………………. [tables]
5 ~ Table owner (owner) ………………… []
6 ~ Table names (tables) ……………….. []
7 – Confirmation mode (confirm) …………. [yes]
8 – Extended output (output) ……………. [no]
9 – Scrolling line count (scroll) ……….. [20]
10 – Message language (language) …………. [E]
11 – BRSPACE command line (command) ………. [-p init<SID>.sap -s 20 -l E -f tbimport -y tables -x /oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
5
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.12
BR0663I Your choice: ‘5’
BR0681I Enter string value for “owner” []:
SAPECC
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.15
BR0683I New value for “owner”: ‘SAPECC’
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.15
BR0657I Input menu 94 – please enter/check input values
——————————————————————————-
BRSPACE options for import tables
1 – BRSPACE profile (profile) …………… [init<SID>.sap]
2 – Database user/password (user) ……….. [/]
3 ~ BRSPACE export run / dump file (export) . [/oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp]
4 ~ Import type (type) …………………. [tables]
5 ~ Table owner (owner) ………………… [SAPECC]
6 ~ Table names (tables) ……………….. []
7 – Confirmation mode (confirm) …………. [yes]
8 – Extended output (output) ……………. [no]
9 – Scrolling line count (scroll) ……….. [20]
10 – Message language (language) …………. [E]
11 – BRSPACE command line (command) ………. [-p init<SID>.sap -s 20 -l E -f tbimport -y tables -o SAPECC -x /oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
6
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.18
BR0663I Your choice: ‘6’
BR0681I Enter string value for “table” []:
E070L
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.24
BR0683I New value for “table”: ‘E070L’
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.24
BR0657I Input menu 94 – please enter/check input values
——————————————————————————-
BRSPACE options for import tables
1 – BRSPACE profile (profile) …………… [init<SID>.sap]
2 – Database user/password (user) ……….. [/]
3 ~ BRSPACE export run / dump file (export) . [/oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp]
4 ~ Import type (type) …………………. [tables]
5 ~ Table owner (owner) ………………… [SAPECC]
6 ~ Table names (tables) ……………….. [E070L]
7 – Confirmation mode (confirm) …………. [yes]
8 – Extended output (output) ……………. [no]
9 – Scrolling line count (scroll) ……….. [20]
10 – Message language (language) …………. [E]
11 – BRSPACE command line (command) ………. [-p init<SID>.sap -s 20 -l E -f tbimport -y tables -o SAPECC -t E070L -x /oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.29
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…
BR0291I BRSPACE will be started with options ‘-p init<SID>.sap -s 20 -l E -f tbimport -y tables -o SAPECC -t E070L -x /oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp’
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.29
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRTOOLS time stamp: 2015-05-12 03.36.32
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…
###############################################################################
BR1001I BRSPACE 7.20 (31)
BR1002I Start of BRSPACE processing: seqmkdoi.tbi 2015-05-12 03.36.32
BR0484I BRSPACE log file: /oracle/<SID>/sapreorg/seqmkdoi.tbi
BR0280I BRSPACE time stamp: 2015-05-12 03.36.34
BR1009I Name of database instance: <SID>
BR1010I BRSPACE action ID: seqmkdoi
BR1011I BRSPACE function ID: tbi
BR1012I BRSPACE function: tbimport
BR0280I BRSPACE time stamp: 2015-05-12 03.36.35
BR0657I Input menu 363 – please enter/check input values
——————————————————————————-
Main options for import from dump file /oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp
1 * Import utility (utility) …………… [IMPDP]
2 – Import type (type) ………………… [tables]
3 – Owner for import (owner) …………… [SAPECC]
4 ~ Tables for import (tables) …………. [E070L]
5 – Import table rows (rows) …………… [yes]
6 – Import table indexes (indexes) ……… [yes]
7 – Import table constraints (constraints) . [yes]
8 – Import table grants (grants) ……….. [yes]
9 – Import table triggers (triggers) ……. [yes]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2015-05-12 03.37.07
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…
BR0280I BRSPACE time stamp: 2015-05-12 03.37.07
BR0657I Input menu 364 – please enter/check input values
——————————————————————————-
Additional options for import from dump file /oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp
1 # Import buffer size in KB (buffer) ……. [10240]
2 # Commit after each array insert (commit) . [yes]
3 # Ignore creation errors (ignore) ……… [no]
4 – Table exists action (action) ………… [skip]
5 – Parallel degree (parallel) ………….. [1]
6 # Max. size of dump file in MB (filesize) . []
7 – Force table import (force) ………….. [no]
8 – IMP/IMPDP command (command) …………. [/oracle/<SID>/112_64/bin/impdp parfile=/oracle/<SID>/sapreorg/seqmkdoi/parfile.imp]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
7
BR0280I BRSPACE time stamp: 2015-05-12 03.37.11
BR0663I Your choice: ‘7’
BR0681I Enter string value for “force” (yes|no) [no]:
yes
BR0280I BRSPACE time stamp: 2015-05-12 03.37.13
BR0683I New value for “force”: ‘yes’
BR0280I BRSPACE time stamp: 2015-05-12 03.37.13
BR0657I Input menu 364 – please enter/check input values
——————————————————————————-
Additional options for import from dump file /oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp
1 # Import buffer size in KB (buffer) ……. [10240]
2 # Commit after each array insert (commit) . [yes]
3 # Ignore creation errors (ignore) ……… [no]
4 – Table exists action (action) ………… [skip]
5 – Parallel degree (parallel) ………….. [1]
6 # Max. size of dump file in MB (filesize) . []
7 – Force table import (force) ………….. [yes]
8 – IMP/IMPDP command (command) …………. [/oracle/<SID>/112_64/bin/impdp parfile=/oracle/<SID>/sapreorg/seqmkdoi/parfile.imp]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
4
BR0280I BRSPACE time stamp: 2015-05-12 03.37.25
BR0663I Your choice: ‘4’
BR0681I Enter string value for “action” (skip|append|truncate|replace) [skip]:
replace
BR0280I BRSPACE time stamp: 2015-05-12 03.37.31
BR0683I New value for “action”: ‘replace’
BR0280I BRSPACE time stamp: 2015-05-12 03.37.31
BR0657I Input menu 364 – please enter/check input values
——————————————————————————-
Additional options for import from dump file /oracle/<SID>/sapreorg/seqmkcpf.edd/expdat.dmp
1 # Import buffer size in KB (buffer) ……. [10240]
2 # Commit after each array insert (commit) . [yes]
3 # Ignore creation errors (ignore) ……… [no]
4 – Table exists action (action) ………… [replace]
5 – Parallel degree (parallel) ………….. [1]
6 # Max. size of dump file in MB (filesize) . []
7 – Force table import (force) ………….. [yes]
8 – IMP/IMPDP command (command) …………. [/oracle/<SID>/112_64/bin/impdp parfile=/oracle/<SID>/sapreorg/seqmkdoi/parfile.imp]
Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2015-05-12 03.38.42
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…
BR0370I Directory /oracle/<SID>/sapreorg/seqmkdoi created
BR0280I BRSPACE time stamp: 2015-05-12 03.38.42
BR1442I Import parameter file /oracle/<SID>/sapreorg/seqmkdoi/parfile.imp created
BR1172I Import of tables will be started with command line: /oracle/<SID>/112_64/bin/impdp parfile=/oracle/<SID>/sapreorg/seqmkdoi/parfile.imp
BR0280I BRSPACE time stamp: 2015-05-12 03.38.42
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRSPACE time stamp: 2015-05-12 03.39.26
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…
BR0278I Command output of ‘/oracle/<SID>/112_64/bin/impdp parfile=/oracle/<SID>/sapreorg/seqmkdoi/parfile.imp’:
Import: Release 11.2.0.3.0 – Production on Tue May 12 03:39:27 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table “SYS”.”BR_IMPORT_SEQMKDOI” successfully loaded/unloaded
Starting “SYS”.”BR_IMPORT_SEQMKDOI”: /******** AS SYSDBA parfile=/oracle/<SID>/sapreorg/seqmkdoi/parfile.imp
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported “SAPECC”.”E070L” 5.414 KB 1 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job “SYS”.”BR_IMPORT_SEQMKDOI” successfully completed at 03:39:32
BR0280I BRSPACE time stamp: 2015-05-12 03.39.32
BR1166I 1 table imported by IMPDP utility
BR0280I BRSPACE time stamp: 2015-05-12 03.39.33
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
Nice
Thank you!