cancel
Showing results for 
Search instead for 
Did you mean: 

Copy cluster table from Production to Quality

Former Member
0 Kudos

Dear All,

The quality server's client was refresh from production before two days. By mistake developer has deleted data from BSEG table (cluster table) in quality server.

How to copy data of only BSEG cluster table from production to quality.

Thanks in Advance,

Nirav

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

.

Former Member
0 Kudos

Hi ,

This is the exact procedure

cat filename.ctrl

export

client =<give your cliennt number>

file =" <give location where you want to create file>file.data

SELECT * FROM <Table Name>

finally execute following script

R3trans -w <lcoation of your scrit file > filename.log filename.cntrl

      • Export is done ***

Import

Create script

cat import.cntrl

import

client=<client number>

file="<file location where you exported data in above step>

Execute it in same way as above exprt ecript

      • done ***

finallly check logs of import

Thanks and Regards

Arun Rathour

Former Member
0 Kudos

You can get the table in the transport from production and then get it done in Quality.

Thanks

Rishi Abrol

Former Member
0 Kudos

Hi Rishi,

Thanks for your quick response.

Can you just tell me the steps to transport. I have tried with SM30 but it givs "The maintenance dialog for BSEG is incomplete or not defined" error.

Thanks,

Nirav

Former Member
0 Kudos

Nirav,

Ask your database team to take the copy of the BSEG table at database level in PRD and then import into QA at database level.

This solves your problem.

We did this after client copy because we excluded the cluster tables during export.

Try this one.

Regards,

Raja. G

Former Member
0 Kudos

Raja G.

Thanks for your reply.

Requst you to please tell us the steps :

As it is cluster table how to copy at database level ?

Thanks,

Nirav

Former Member
0 Kudos

Nirav,

As i told you earlier, it has been done by our database team.

We just provide the list of top 10 tables in that COEP table also there. COEP is a cluster table.

They only copied the table. We just checked at SAP Level.

Pls get in touch with your DB team for more details. They may aware of those things.

Regards,

Raja. G

Former Member
0 Kudos

How to provide tables invoived in Cluster BSEG. From where I get this information.

Thanks,

Nirav

Former Member
0 Kudos

Nirav,

From SE11, you can get the tables involved in the cluster table.

I think if you told to your DB team they ll get all those details at DB level.

Just give the BSEG table, they ll find.

Regards,

Raja. G