[prasad]

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.