September 8, 2008 at 7:29 am
I am pushing data from SQL SERVER TO ORACLE,
So, I can audit the job from sql server.
But how in oracle..?
when we insert data into a table in oracle database,
how to know who inserted the data and when.:)
could u any body give reply to this question really appreciate to them
September 8, 2008 at 7:54 am
If you can audit it in SQL server, why would you need to repeat the same task with the same results in Oracle?
September 8, 2008 at 7:54 am
I would assume Oracle has some sort of transaction log, which you could use for that.
You might be better off asking that question on an Oracle forum, since this is SQL Server, and there might be more people who can answer you on some other page.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 22, 2008 at 8:48 pm
kumar99ms (9/8/2008)
I am pushing data from SQL SERVER TO ORACLE,So, I can audit the job from sql server.
But how in oracle..?
when we insert data into a table in oracle database,
how to know who inserted the data and when.:)
could u any body give reply to this question really appreciate to them
You cannot know, in Oracle, what or who inserted the data or when on an SQL Server table. To do that, you must add a CreatedBy and CreatedOn set of columns to the tables on the SQL Server side of the house. The CreatedBy column should have a default of SYSTEM_USER and the CreatedOn column should have a default of GETDATE().
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply