Announcement

Collapse
No announcement yet.

Archiving data from Glogowner to Archive Schema

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Archiving data from Glogowner to Archive Schema

    Hi,

    Does anyone have any suggestions on the best practices for archiving & purging the data? We are in the process of moving old data from GLOGOWNER schema to the ARCHIVE schema. We are using the standard Data Purge process. However, this is a very time consuming process. Is there a faster way to move the data to the ARCHIVE schema? Are there any scripts that do this?



    Thanks,
    Prasad.
    Thanks,
    Prasad.

  • #2
    Re: Archiving data from Glogowner to Archive Schema

    Hello,

    Could you please help me with this,

    We have used the standard Data purge process to purge a few shipments. We received an Email notification highlighting the total number of shipments purged.However , on accesing the Archive_object table , we fail to find the purged shipments.

    We are unable to get an access to those shipments. Is there some alternative way to do it or are we missing something ?

    Thanks

    Comment


    • #3
      Re: Archiving data from Glogowner to Archive Schema

      Medhas,

      You will find the purged shipments in the Archive Schema. All the table names will end with _DMP. For example the SHIPMENT table will be called SHIPMENT_DMP.

      You should be able to see all the shipment information in the SHIPMENT_DMP table.

      Prasad.
      Thanks,
      Prasad.

      Comment


      • #4
        Re: Archiving data from Glogowner to Archive Schema

        Thanks Prasad. How do we access the archive schema? We have been trying to look out for shipment_dmp . But it doesnt seem to exist.
        Further, this table is not listed even in the data dictionary.\

        Regards

        Comment


        • #5
          Re: Archiving data from Glogowner to Archive Schema

          Medhas,

          You can try this.

          select * from ARCHIVE.SHIPMENT_DMP where shipment_xid=?;
          All the table sin the archive schema end with _DMP.

          If you use a tool like TOAD then you can see all the schemas and the tables in the schema browser.

          Thanks,
          Prasad.
          Thanks,
          Prasad.

          Comment


          • #6
            Re: Archiving data from Glogowner to Archive Schema

            Hey prasad

            Thanks, we are able to view our archived shipments now .

            Thanks ,
            Medha

            Comment

            Working...
            X
            😀
            🥰
            🤢
            😎
            😡
            👍
            👎