Re: Last Update

2001-07-17 Thread Shreepad Vaidya
Hi, Thanks for the clarification. Always welcome. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: However you can query the view dba_tab_modifications for checking when and how many updates/deletes/inserts/truncate have been

RE: Last Update

2001-07-17 Thread lhoska
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

RE: Last Update

2001-07-17 Thread Hillman, Alex
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

RE: Last Update

2001-07-17 Thread DBarbour
sys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Last Update

RE: Last Update

2001-07-17 Thread MacGregor, Ian A.
Sigh on as sys and you'll see it in 8i. I don't think it is part of the 7.3.4 database, but then I haven't looked. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 17, 2001 10:58 AM To: Multiple recipients of list ORACLE-L

RE: Last Update

2001-07-17 Thread Ron Rogers
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,

RE: Last Update

2001-07-17 Thread JOE TESTA
8.1.7 on aix, it exists just fine. joe [EMAIL PROTECTED] 07/17/01 01:57PM Guys,can you please confirm to me you found dba_tab_modifications table. Ichecked 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

RE: Last Update

2001-07-17 Thread Rachel Carmichael
I did a check -- you have to have MONITORING on on the table you are modifying for the view to be filled. From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Last Update Date: Tue, 17 Jul 2001 10:55:33 -0800

RE: Last Update

2001-07-17 Thread JOE TESTA
you need to have turned monitoring on the the table(s). alter table tablename monitoring; joe [EMAIL PROTECTED] 07/17/01 02:55PM 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

RE: Last Update

2001-07-17 Thread Mohammad Rafiq
If you want that other users like system can see it ,give grant select to system as user sys... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 17 Jul 2001 10:20:31 -0800 It is not a table - it is a view owned by sys. And it

RE: Last Update

2001-07-17 Thread Hillman, Alex
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

Re: Last Update

2001-07-16 Thread Shreepad Vaidya
Hi Erik, Check out the dba_objects tables. There is a column called as Last_ddl_time , which will give the ddl time. But if you want to capture select,insert,delete,update times ? I guess you will have to write trigger and capture the times. HTH shreepad

Re: Last Update

2001-07-16 Thread Christian Trassens
alter table monitoring. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi Erik, Check out the dba_objects tables. There is a column called as Last_ddl_time , which will give the ddl time. But if you want to capture select,insert,delete,update times ? I guess you will have to write

Re: Last Update

2001-07-16 Thread Arul kumar
Hi, but in my 8.1.7 db. (on SOLARIS), NO ROWS SELECTED when queried DBA_TAB_MODIFICATIONS... Any init parameters to be enabled?? Arul. Christian Trassens wrote: However you can query the view dba_tab_modifications for checking when and how many

RE: Last Update

2001-07-16 Thread Mark Leith
If you have just set a table as monitoring (and have no other tables already set for this option), then you may not actually see any rows in this table for a while. The one downfall with this option (if you want/need real time info) is that this table may not update for some time after the

Re: Last Update

2001-07-16 Thread Christian Trassens
Andthen wait because the SMON updates it every three hours or after an startup. Regards. PS: Even that you can manually wakeup the SMON through oradebug wakeup orapid of SMON --- JOE TESTA [EMAIL PROTECTED] wrote: you have to turn monitoring on for each table. alter table tablename

RE: Last Update

2001-07-13 Thread JOE TESTA
You could use logminer to see when something changed(the whole sql) but it doesn't track a last updated date per se. joe [EMAIL PROTECTED] 07/13/01 02:55PM Erik,AFAIK, you will have to maintain that ... I don't think Oracle maintainsthat information ... now in my wildest guess I could

RE: Last Update

2001-07-13 Thread Kevin Lange
I am afraid the only fields I know about are the last_analyzed date in DBA_TABLES and the last_DDL_time in the dba_objects table. -Original Message- Sent: Friday, July 13, 2001 1:42 PM To: Multiple recipients of list ORACLE-L How can I tell when a table was last updated? I am able to