otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


Database Administration Database installation, creation, administration and related topics.

Tags: , ,

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old May 6th, 2008, 19:30
Junior Member
 
Join Date: Mar 2007
Posts: 20
Thanks: 4
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
prasad is on a distinguished road
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old September 11th, 2008, 13:34
Junior Member
 
Join Date: Sep 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
medhas is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old September 11th, 2008, 14:29
Junior Member
 
Join Date: Mar 2007
Posts: 20
Thanks: 4
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
prasad is on a distinguished road
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old September 15th, 2008, 07:49
Junior Member
 
Join Date: Sep 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
medhas is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old September 15th, 2008, 14:44
Junior Member
 
Join Date: Mar 2007
Posts: 20
Thanks: 4
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
prasad is on a distinguished road
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old September 16th, 2008, 11:44
Junior Member
 
Join Date: Sep 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
medhas is on a distinguished road
Re: Archiving data from Glogowner to Archive Schema

Hey prasad

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

Thanks ,
Medha
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
OTM Archiving For Invoices ianlo SysAdmin and Management 4 September 18th, 2008 07:19
Archive Schema is not populated during Purging prasad Database Administration 3 February 26th, 2008 16:44
Creating the Empty schema gokul Database Administration 1 December 28th, 2007 05:56
Impact of changing the glogowner password bluesdude SysAdmin and Management 3 December 11th, 2007 03:29
Purging and Archiving chad Database Administration 10 November 29th, 2007 12:10



All times are GMT. The time now is 17:16.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37