chjagge
23rd June 2003, 19:16
Not sure if I should have posted this under Manufacturing, but I'm starting here. Has anyone run into the problem where tables are being dropped using session timrp1210m000 (as it should when running it Regen) but not recreated. Its not consistent and there is no pattern I can see. Baan solution was to upgrade from porting set 6.1c.06.03 to 6.1c.06.07. But I have not seen anything in the bug fixes that addresses this problem.

patrickmonks
24th June 2003, 17:40
The old timrp1210m000 (B2) did a
delete of all the records, but the c4 one
does a drop and re-create of the table.

The problem we had was that we ran with
a very small ora_storage (Not able to create tables
on the fly). You need to check
that the user that run the timrp1210m000 session
is able to create the tables in question.

If not then check it out.

What we did in the end
was changed the source to do deletes from the tables
and not drops.