| 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: Last Update
For table to have a record in dba_tab_modifications it need to be monitored.
use alter table <table_name> monitoring
Also it takes some time for Oracle to change record in dba_tab_modifications. Approximately 3 hours.
Alex Hillman
-----Original Message-----
Sent: Tuesday, July 17, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
Alex,
I did a describe on sys.dba_tab_modifications and it shows a lot of info. I
select * from the view and no rows were returned but I have inserted and
truncated a lot of data this morning. Does it matter the userid doing the
work? I have created a userid that has the insert, del, update, sel privs on
the tables that get changed each morning.
OS linux 7.0
Oracle 8.1.7
Your thoughts?
ROR mª¿ªm
>>> Alex.Hillman_at_usmint.treas.gov 07/17/01 02:20PM >>>
It is not a table - it is a view owned by sys. And it exists only in 8i+
Alex Hillman
-----Original Message-----
Sent: Tuesday, July 17, 2001 1:58 PM
To: Multiple recipients of list ORACLE-L
Guys,
can you please confirm to me you found dba_tab_modifications table. I
checked both 7.3.4 and 8i versions and I don't seem to find the table.
Thank you.
-----Original Message-----
Sent: Tuesday, July 17, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L
Hi,
Thanks for the clarification. Always welcome.
shreepad
To: Shreepad Vaidya/EMEA/ALLTELCORP, ORACLE-L_at_fatcity.com AT
INTERNET_at_CCMAIL
cc:
However you can query the view dba_tab_modifications
for checking when and how many
updates/deletes/inserts/truncate have been done on the
table. If this is enough, great, don't you think so ?.
Regards.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: ctrassens_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: Shreepad.Vaidya_at_alltel.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: lhoska_at_calibresys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: Alex.Hillman_at_usmint.treas.gov Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: RROGERS_at_galottery.org Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: Alex.Hillman_at_usmint.treas.gov Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Jul 17 2001 - 13:30:15 CDT
 |
 |