on 08-11-2009 8:51 AM
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
.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You can get the table in the transport from production and then get it done in Quality.
Thanks
Rishi Abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
88 | |
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.