system copy - secure tables and then import
Warning - this is just a way save yourself some reworking after a system copy - that is not supported by SAP and must be tested for each new release if the tables are up to date!
first need to create a control file for export:
export file = '/ tmp / export_SID.exp'
# RFC tables
delete from RFCTRUST
select * from RFCTRUST
delete from RFCSYSACL
select * from RFCSYSACL
delete from RFCDOC
select * from RFCDOC
delete from RFCDESSECU
select * from RFCDESSECU
delete from RFCDES
select * from RFCDES
delete from RFCCHECK
select * from RFCCHECK
delete from RFCATTRIB
select * from # RFCATTRIB
Secstore secure
from RSECACHK
select * from RSECACHK
delete from RSECACTB
select * from RSECACTB
delete delete from RSECTAB
select * from # RSECTAB
CRM tables
delete from crmrfcpar
select * from crmrfcpar
delete from crmprls
select * from crmprls
delete from tblsysdest
select * from # tblsysdest
DBCON compounds
delete from DBCON
select * from # DBCON
SMLG / RZ12 Lastverteilgun
delete from RZLLITAB
select * from # table RZLLITAB
instvers
delete from instvers
select * from instvers
# RZ10 Profile
secure delete from TPFET
select * from TPFET
delete from TPFHT
select * from TPFHT
delete from TPFID
select * from TPFID
The delete statements are valid only on import. When exporting
have been ineffective, but must also be specified!
will Exports started as follows:
R3trans-w log control file starts
import
file = '/ tmp / export_SID.exp'
The import with the same call::
The import control file should look something like
R3trans-w log control file
0 comments:
Post a Comment