| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Any Powermart user out there ?
Stephane,
Env't:: Oracle 8i, HP-UX 11.0 (64 bit)
We use PowerMart 4.7 to populate our various data warehouse databases
(operational data store, data warehouse, data mart).
We use only one Oracle ID named INTERFACE in each database to move data
between the database application schemas.
It owns a stored procedure named pre_table_trunc with some parms to
identify the table, schema, mapping and output.
Unfortunately, the interface ID does need to have the requisite 'delete any
table' system privilege.
We also use PM to delete rows from a table if the table has a key common to
the rows to be deleted like acct_date.
HTH,
Steve Haas
DBA/Informatica Consultant
@ Royal & SunAlliance
Farmington, CT USA
paquette stephane <stephane_paquette_at_yahoo.com> on 11/02/2000 11:05:42 AM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Steven P. Haas/Waterside/EBICO) Subject: Any Powermart user out there ?
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
 |
 |