OAJ Purge Data

[Duc M Do]

​Hi list & Ricardo,

I purge the OAJ data from my Foxray database once a year. The purged data are kept in the Archive directory, and it's a text file. So far so good.

I just got a request from a user in search of OAJ data going back beyond the purge date, into the period that has been purged.

Questions: Is loading the purged data back into the current OAJ table my only avenue? Or can I create a temporary OAJ table to load the purged data into it, do the query, and discard the temporary table? (If yes to the latter, how to do that?)

Thanks!

Duc

Carrollton Plant, Dow Corning Corp.

A wholly-owned subsidiary of the Dow Chemical Company

[Ricardo Abech]

You can do it. just create a new network and then load into that network instead of the original one. 

Then you should be able to query that and discard when finish

Let me know if you face any issues 

Thanks 

--
You received this message because you are subscribed to the Google Groups "LimeWare foxray™" group.
To unsubscribe from this group and stop receiving emails from it, send an email to limeware-foxray+unsubscribe@googlegroups.com.
To post to this group, send email to limeware-foxray@googlegroups.com.
Visit this group at https://groups.google.com/group/limeware-foxray.
For more options, visit https://groups.google.com/d/optout.

[Duc M Do]

Ricardo,

Okay, that sounds reasonable enough.​ I'm looking at the Server Configurator right now, so I don't even have to go hunting for how to create a new network.

Thanks!

Duc

[Ricardo Abech]

I just tested the procedure here and works just fine.

Let me know if works well for you

[Duc M Do]

Ricardo,

I created​ a dummy network and loaded the purged OAJ data, about 2 GB worth of it, into the OAJ table. Works great. Thanks for the help.

Duc

[ricardoabech]

Great. always glad to help

Sent via the Samsung Galaxy S® 6, an AT&T 4G LTE smartphone

To unsubscribe from this group and stop receiving emails from it, send an email to limeware-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

[Dirk Pauwels]

Duc,

 

Why would you purge the dbse records after 1 year? We have 5 or 6 years in the dbse. Not that we need it, but it’s easier to keep it than to create a dummy network and load the purged data……

 

Mvg,

 

Dirk Pauwels
DCS/MOC Coordinator

Ketenislaan 1C - Haven 1520
B-9130 Kallo, Belgium

Dirk.P...@lawter.com

tel: +32 3 570 95 97
mob: +32 497 428 300

To unsubscribe from this group and stop receiving emails from it, send an email to limeware-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

Visit this group at https://groups.google.com/group/limeware-foxray.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "LimeWare foxray™" group.

To unsubscribe from this group and stop receiving emails from it, send an email to limeware-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

Visit this group at https://groups.google.com/group/limeware-foxray.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "LimeWare foxray™" group.

To unsubscribe from this group and stop receiving emails from it, send an email to limeware-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

Visit this group at https://groups.google.com/group/limeware-foxray.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "LimeWare foxray™" group.

To unsubscribe from this group and stop receiving emails from it, send an email to limeware-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

Visit this group at https://groups.google.com/group/limeware-foxray.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "LimeWare foxray™" group.

To unsubscribe from this group and stop receiving emails from it, send an email to limeware-foxr...@googlegroups.com.
To post to this group, send email to limewar...@googlegroups.com.

Visit this group at https://groups.google.com/group/limeware-foxray.
For more options, visit https://groups.google.com/d/optout.

---

Lawter Notice: The information (including any attachments) contained in this communication is confidential, private and proprietary, may be privileged or otherwise protected by applicable law or legal rule, and is intended only for the use of the addressee(s). Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately by reply e-mail, or by calling the sender, and then delete it completely from your system.

[Duc M Do]

I just like to make my life harder!

But seriously, we were previously hampered by the 8 GB RAM limit imposed by the OS (Windows Server 2003) on our Foxray server, hence a desire for a trim database corpus. Earlier this year, we upgraded the hardware and OS to run Windows Server 2008 Enterprise at 64 bits with loads of RAM, so the need to keep a trim database is not as important as before. I might have to rethink my housekeeping procedure now in light of that improvement.

Duc