cancel
Showing results for 
Search instead for 
Did you mean: 

How to run BRSPACE with import/export but with different schema id

Former Member
0 Kudos

Hi,

We have to move some tables from one SAP database to another SAP database.

The schema-id of the source is SAPR3 and the schema-id of the target is SAPSR3.

Is it possible to use BRSPACE or some other SAP tool to move a table in this setting?

Thanks for the help!!!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

yes it is possible to use brspace. Proceed normal as if you would simply transfer the table(s).

During the import, note this step:

BR0280I BRSPACE time stamp: 2011-10-06 11.31.44
BR1442I Import parameter file /oracle/SID/sapreorg/segxyols/parfile.imp created

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

BR0280I BRSPACE time stamp: 2011-10-06 11.31.44
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

Here you have to manually edit the file parfile.imp, make sure that fromuser and touser are correct, then brspace will import your tables into another schema. For me it worked fine.

Regards,

Mark

Answers (0)