Home » SQL & PL/SQL » SQL & PL/SQL » How to find out last DML operation in a table which does not have date field (Oracle 9i)
How to find out last DML operation in a table which does not have date field [message #437097] Thu, 31 December 2009 01:30 Go to next message
sanjoyp158
Messages: 19
Registered: June 2007
Junior Member
I have one table which does not have any date field.
But I want to know the date when the records are inserted into the tables.

Please help me in this case, because I am facing problem with my current project.

It will be better if you can give me reference table name,so that I can see without DBA privilege.
Re: How to find out last DML operation in a table which does not have date field [message #437099 is a reply to message #437097] Thu, 31 December 2009 01:39 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yes it is possible when ever if you have any of the the following
If you have Log Miner configured
If you have audit enabled on that table
If you have Any trigger enable on that table

Then check those logs.
This will help you
sriram Smile
Re: How to find out last DML operation in a table which does not have date field [message #437101 is a reply to message #437099] Thu, 31 December 2009 01:42 Go to previous messageGo to next message
sanjoyp158
Messages: 19
Registered: June 2007
Junior Member
Hi Sriram, i don't have any of the followings :

Log Miner configured
Audit enabled on that table
Any trigger enable on that table

Even I don't have the DBA privilege.

Please help.
Re: How to find out last DML operation in a table which does not have date field [message #437103 is a reply to message #437101] Thu, 31 December 2009 01:52 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So you'd like to go to the Moon, but all you have is your left shoe.

Perhaps you should talk to your DBA, explain what you need and ask for help.
Re: How to find out last DML operation in a table which does not have date field [message #437175 is a reply to message #437097] Thu, 31 December 2009 12:35 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Maybe the ORA_ROWSCN Pseudocolumn will help.

Check out the definition in the fine Oracle® Database SQL Reference


[Updated on: Wed, 20 October 2010 12:11] by Moderator

Report message to a moderator

Re: How to find out last DML operation in a table which does not have date field [message #437176 is a reply to message #437175] Thu, 31 December 2009 12:42 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA_ROWSCN to be accurate requires to create the table with ROWDEPENDENCIES option (it can't be added afterwards) and it allows to get the scn (and so time) of the last modification of the rows.
So if a row is modified after it has been inserted, time will not be insert time.

Regards
Michel
Previous Topic: column to rows
Next Topic: wildcard character
Goto Forum:
  


Current Time: Fri Feb 07 15:08:14 CST 2025