Archiving data from Glogowner to Archive Schema

[prasad]

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.

[medhas]

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

[prasad]

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.

[medhas]

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

[prasad]

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.

[medhas]

Re: Archiving data from Glogowner to Archive Schema

Hey prasad

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

Thanks ,
Medha