Home » SQL & PL/SQL » SQL & PL/SQL » can i able to view the rows recently inserted?
can i able to view the rows recently inserted? [message #295122] Mon, 21 January 2008 06:39 Go to next message
sathish.mellow
Messages: 32
Registered: December 2007
Location: Chennai
Member
hi

please suggest an idea to view the rows recently inserted?

Regards,
Sathish
Re: can i able to view the rows recently inserted? [message #295132 is a reply to message #295122] Mon, 21 January 2008 06:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
- Add a timestamp column to your table.
- If you are in 10g and have enable it, use ora_rowscn pseudocolumn
- If you are in 10g and have the privileges, use flahsback transation query.
- You can use Log Miner.

Regards
Michel

Re: can i able to view the rows recently inserted? [message #295248 is a reply to message #295122] Mon, 21 January 2008 21:36 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Hi

IF im using 9i what should i want to do.

regards

Kanish
Re: can i able to view the rows recently inserted? [message #295271 is a reply to message #295248] Mon, 21 January 2008 23:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Those that I didn't flag with 10g.

Regards
Michel
Re: can i able to view the rows recently inserted? [message #295282 is a reply to message #295122] Tue, 22 January 2008 00:11 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

hi

Sorry to distrib u Michel
Im very blank

Where should i want to check lock miner.

wbr
kanish
Re: can i able to view the rows recently inserted? [message #295287 is a reply to message #295282] Tue, 22 January 2008 00:25 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Oracle9i Database Administrator's Guide
Chapter 9 Using LogMiner to Analyze Redo Logs

Regards
Michel
Previous Topic: sum of distinct records data
Next Topic: Hierarchical query exclusions
Goto Forum:
  


Current Time: Mon Feb 10 11:54:04 CST 2025