Skip to Content
avatar image
Former Member

Copy cluster table from Production to Quality

Aug 11, 2009 at 07:51 AM | 34 Views

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

NW AS Java Administrator (NWA)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 11, 2009 at 08:15 AM

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

    Thanks

    Rishi Abrol

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Aug 12, 2009 at 10:18 AM

      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

  • avatar image
    Former Member
    Aug 13, 2009 at 12:26 PM

    .

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 14, 2009 at 06:06 AM

      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