I need a little help.
I am working on an Oracle 10.2.0.4 in Windows environment.
I have a table I created like this:
Table name: DIM_REPLICA
On this DB I have 210 refresh groups executing every night. I need to populate this table with the outcome of the refresh groups.
So when the refresh group called for example ROME runs I need written on the table the name ROME in the "NOME_SEZ" field, a Y or a N if the refresh group worked correctly in the FLAG field and the LAST_DATE the refresh group ran in the D_REPLICA field. The COD_SEZ field is a code I get from other things. It is not needed at the moment. I can add it myself on me own.
Can anyone please help me?
I was looking on SYS tables DBA_JOBS and DBA_REFRESH for this data, but I am not sure what to take and how to populate the table. Trigger? Procedure? Any help will be great!
Thank you all in advance!
This forum is for SQL*PLus issues and your question is about general Oracle issues. You will get a better answer by posting your question in another forum - probably the General Database Forum.
Please close this thread and start again in another forum.