jgersic64
Active Member
I have an interesting one here, and the only thing I could think of is
possibly using table conversions but even then it is stick: My former
employer wishes to purge the JDE system, across the board/all tables, of
data that is older than a given date. I said I know of particular UBE's that
clear out particular tables, but nothing that does it globally..any ideas to
this? They are running B733.1 SP11 (last I heard) with Oracle 8.15 on NT..
John
Xe, SP16/Update 2, NT/SQL, WTS/Metaframe 1.8
----------------------------------------------------------------
John Gersic
Financial Systems DBA
703.744-6057
1861 International Drive
McLean, Virginia 22102
MicroStrategy-Best in Business Intelligence
http:/www.microstrategy.com/ <http:/www.microstrategy.com/>
-----------------------------------------------------------------
possibly using table conversions but even then it is stick: My former
employer wishes to purge the JDE system, across the board/all tables, of
data that is older than a given date. I said I know of particular UBE's that
clear out particular tables, but nothing that does it globally..any ideas to
this? They are running B733.1 SP11 (last I heard) with Oracle 8.15 on NT..
John
Xe, SP16/Update 2, NT/SQL, WTS/Metaframe 1.8
----------------------------------------------------------------
John Gersic
Financial Systems DBA
703.744-6057
1861 International Drive
McLean, Virginia 22102
MicroStrategy-Best in Business Intelligence
http:/www.microstrategy.com/ <http:/www.microstrategy.com/>
-----------------------------------------------------------------