Any Powermart user out there ?

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Thu, 2 Nov 2000 08:04:14 -0800 (PST)
Message-Id: <10668.120971@fatcity.com>

Hi,

The dev team is using Powermart as the ETL tool. They are empying the working tables before each load. To do that Powermart is using a truncate instead of a delete.

That goes against my setup as the user running Powermart is not the owner of the tables but another user with select,update,delete,insert privileges. Of course that user can not do truncate table.

I have for principle that the owner of the tables is never used to run jobs.

Can Powermart uses delete to empty the tables ? The number of rows are quite small, less than 50 000 rows per table.

TIA

---

Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

---

Received on Thu Nov 02 2000 - 10:04:14 CST