OraFAQ Forum: SQL & PL/SQL » KNOW THE TABLE STATUS

Home » SQL & PL/SQL » SQL & PL/SQL » KNOW THE TABLE STATUS

Fri, 26 September 2003 05:57

Rehman
Messages: 19
Registered: February 2000

Junior Member

HOW CAN I KNOW WHEN TABLE IS ALTERED

Fri, 26 September 2003 06:16

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

  1* select last_ddl_time from user_objects where object_name='DEPT'
mag@mutation_mutation > /

LAST_DDL_
---------
24-SEP-03

Previous Topic:	ALTER TABLE DEALLOCATE UNUSED
Next Topic:	suppressing unwanted entries while spooling of data

Goto Forum:

]

Current Time: Thu Apr 25 01:19:53 CDT 2024