RE: Clearing tables in Prototype

[cdawes]

RE: Clearing tables in Prototype

There's a great excel spreadsheet on the Knowledge Garden that lists all OW
tables and their usage. I can't seem to find it on the Knowledge Garden but
I think I saved a copy. All you need to do is trucate the tables that are
descriped as Tranaction tables. Make sure you backup your Business Data and
Control Tables into a seperate tablespace before you start (just in case you
make a mistake).

Also, check out document OHR-00-0024 on the Knowledge Garden that descripes
all the Payroll Master tables.

Also check your inbox, I'll send you that Excel speadsheet if I ever find
it.

Colin





Colin Dawes, MSc
City of Guelph
B7332 SP15.1, Oracle 8.1.6.3, NT 4.0, Fat & WTS