on 10-06-2011 10:06 AM
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!!!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.