Home » SQL & PL/SQL » SQL & PL/SQL » user_objects - difference between 2 columns
user_objects - difference between 2 columns [message #221146] Sat, 24 February 2007 07:35 Go to next message
pmaupoil
Messages: 40
Registered: February 2007
Location: France
Member
Sorry guys if it is wrong forum but did not know where to post it.

In the user_objects data dictionary view, what is the difference between the timestamp and the last_ddl_time columns?
Re: user_objects - difference between 2 columns [message #221148 is a reply to message #221146] Sat, 24 February 2007 07:45 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Why to post?
Tried Google?
First
Second
By
Vamsi
Re: user_objects - difference between 2 columns [message #221152 is a reply to message #221148] Sat, 24 February 2007 08:17 Go to previous messageGo to next message
pmaupoil
Messages: 40
Registered: February 2007
Location: France
Member
Already did! I would not have posted otherwise...
so what's the difference? When will one get changed and not the other one...?
Re: user_objects - difference between 2 columns [message #221273 is a reply to message #221152] Mon, 26 February 2007 01:45 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I don't think it is that tricky to find out.
Create a temp table/view and change the specification or grant some privilege to some other user.

My Findings:
1. Created a view in user x.(using select * on a table)
Both last_ddl_time and timestamp are same.
2. granted select to user y.
last_ddl_time changed.
3. again created the view using create or replace with select <all columns in same order>
last_ddl_time changed. as the specification didn't get changed, the timestamp is same.
4. again created the view using create or replace with select <with all the columns in different order>
Both last_ddl_time and timestamp got changed.

By
Vamsi
Re: user_objects - difference between 2 columns [message #221286 is a reply to message #221146] Mon, 26 February 2007 03:27 Go to previous message
pmaupoil
Messages: 40
Registered: February 2007
Location: France
Member
Thanks!
Previous Topic: data type problem
Next Topic: Regarding DECODE
Goto Forum:
  


Current Time: Fri Dec 02 14:16:39 CST 2016

Total time taken to generate the page: 0.08684 seconds