Brtools - Import tables from a database to another database?

[Former Member]

Good day!

I have exported tables through brtools from one database successfully. My question is... Is it possible to do an import of these tables to another database?

Copied the directories from the source database to the another database. Ran brtools, segment management, and this is where I get stuck. In line 3, I tried few things ( left it blank, provided the whole path where the expat.dmp, and third try was to provide the file.dmp only) but it is not going through.

1 - BRSPACE profile (profile) ............... [initXXX.sap]

2 - Database user/password (user) ........... [/]

3 ~ BRSPACE export run / dump file (export) . [expdat.dmp]

4 - Confirmation mode (confirm) ............. [yes]

5 - Extended output (output) ................ [no]

6 - Scrolling line count (scroll) ........... [20]

7 - Message language (language) ............. [E]

8 - BRSPACE command line (command) .......... [-p initZZ.sap -s 20 -l E -f tbimport -x expdat.dmp

BR1001I BRSPACE 7.00 (33)

BR1002I Start of BRSPACE processing: segsoeqx.tbi 2011-09-07 14.08.55

BR0484I BRSPACE log file: /oracle/SB3/sapreorg/segsoeqx.tbi

BR0280I BRSPACE time stamp: 2011-09-07 14.08.55

BR1009I Name of database instance:XXX

BR1010I BRSPACE action ID: segsoeqx

BR1011I BRSPACE function ID: tbi

BR1012I BRSPACE function: tbimport

BR1170E Dump file 'expdat.dmp' not found

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRSPACE time stamp: 2011-09-07 11.48.39

BR1009I Name of database instance: XX

BR1010I BRSPACE action ID: segsnsfe

BR1011I BRSPACE function ID: tbi

BR1012I BRSPACE function: tbimport

BR1171E Dump file /oracle/XXX/sapreorg/BBB_export/segnqhah.edd is not a regular file

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

Thoughts?

Thanks

[Former Member]

Suggest to close this thread if your query is answered.

Regards,

Nick Loy

[Former Member]

If both are SAP systems - Try with transport of copies

If target is non-SAP - Use Oracle expdb/impdb method (But make sure that target system doesn't have any of these table)

Regards,

Nick Loy

[Former Member]

Thank you all for the reply. I have used the brtools strategy and was working. Yes, the transport would have been the best way in exporting/importing the data.

[former_member682089]

Hi Kathleen,

If you are talking about exporting data from one DB which is running SAP to another DB which is also running SAP, its recommnded to use SAP STMS process. create a transport request and export data and import request in targetted system.

Sandeep

[Former Member]

Hi Kathleen,

>> BR1171E Dump file /oracle/XXX/sapreorg/BBB_export/segnqhah.edd is not a regular file

You should copy folders related by export named "segnqhah.edd" and "segnqhah" and the file "segsolan.tbe" into the "sapreorg" directory.

Then, you should enter " /oracle/XXX/sapreorg/segnqhah/parfile.imp" to "3 ~ BRSPACE export run / dump file (export)" parameter.

Then execute the import operation.

I hope that it is clear.

Best regards,

Orkun Gedik

[Former Member]

Thanks Orkun for the quick reply.

I ran it again before your reply, wherein, I copied the export directories to the sapreorg directory. Then I got stuck, it did not import the 2 tables that I was trying because of the ORA-0001 error.

I have 34 tables to import to this database and these tables do exist to the new database. How should this be resolved?

1 - Import buffer size in KB (buffer) ....... [10240]

2 - Commit after each array insert (commit) . [yes]

3 - Ignore creation errors (ignore) ......... [yes]

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/XXX/102_64/bin/imp parfile=/oracle/XXX/sapreorg/segsojtm/parfile.imp]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2011-09-07 15.08.10

BR0663I Your choice: '7'

BR0280I BRSPACE time stamp: 2011-09-07 15.08.10

BR0681I Enter string value for "force" (yes|no) [no]:

BR0280I BRSPACE time stamp: 2011-09-07 15.08.16

BR0683I New value for "force": 'yes'

BR0280I BRSPACE time stamp: 2011-09-07 15.08.16

BR0657I Input menu 364 - please enter/check input values

-

---

Additional options for import from dump file: /oracle/XXX/sapreorg/segnqhah.edd/expdat.dmp

1 - Import buffer size in KB (buffer) ....... [10240]

2 - Commit after each array insert (commit) . [yes]

3 - Ignore creation errors (ignore) ......... [yes]

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/XXX/102_64/bin/imp parfile=/oracle/XXX/sapreorg/segsojtm/parfile.imp]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2011-09-07 15.08.33

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2011-09-07 15.08.33

BR0370I Directory /oracle/XXX/sapreorg/segsojtm created

BR1172I Import of tables will be started with command line: /oracle/XXX/102_64/bin/imp parfile=/oracle/XXX/sapreorg/segsojtm/parfile

.imp

BR0280I BRSPACE time stamp: 2011-09-07 15.08.33

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I BRSPACE time stamp: 2011-09-07 15.08.39

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0278I Command output of '/oracle/XXX/102_64/bin/imp parfile=/oracle/XXX/sapreorg/segsojtm/parfile.imp':

Import: Release 10.2.0.4.0 - Production on Wed Sep 7 15:08:40 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Username:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via direct path

import done in WE8DEC character set and AL16UTF16 NCHAR character set

export server uses UTF8 NCHAR character set (possible ncharset conversion)

IMP-00046: using FILESIZE value from export file of 20971520000

. importing SYS's objects into SYS

. importing SAPR3's objects into SAPR3

. . importing table "ZOD_T_NC_CODE"

BR0278E Command output of '/usr/sap/XXX/SYS/exe/run/brtools -f printcmd | /oracle/XXX/102_64/bin/imp parfile=/oracle/XXX/sapreorg/se

gsojtm/parfile.imp':

IMP-00019: row rejected due to ORACLE error 1

IMP-00003: ORACLE error 1 encountered

ORA-00001: unique constraint (SAPR3.ZOD_T_NC_CODE~0) violated

[Former Member]

Hi Kathleen,

This is another issue. Ok, if you are running on a SAP system, you can use STMS to transport table content from a system to another.

Check the document, below;

/people/tom.cenens3/blog/2011/08/31/export-table-content-using-a-transport-of-copies-sapadmin

Best regards,

Orkun Gedik