Home » SQL & PL/SQL » SQL & PL/SQL » low value & high value (Oracle 11g)
low value & high value [message #657063] Thu, 27 October 2016 05:53 Go to next message
saipradyumn
Messages: 320
Registered: October 2011
Location: Hyderabad
Senior Member
Hi All ,

I have created a table.I am able to see some LOW&HIGH values in LOW_VALUE&HIGH_VALUE of the DBA_TAB_COLUMNS.
But I didn't define any range for that column .
How Low value & high value will be populated to ALL_TAB_COLUMNS data dictionary table ?

Re: low value & high value [message #657065 is a reply to message #657063] Thu, 27 October 2016 06:05 Go to previous messageGo to next message
John Watson
Messages: 7255
Registered: January 2010
Location: Global Village
Senior Member
The values are gathered when you analyzed the table with dbms_stats.
Re: low value & high value [message #657207 is a reply to message #657065] Tue, 01 November 2016 06:58 Go to previous message
saipradyumn
Messages: 320
Registered: October 2011
Location: Hyderabad
Senior Member

Thanks a lot for valuable information John.
Previous Topic: Materialized view creation with complex queries
Next Topic: Table compression
Goto Forum:
  


Current Time: Sat Feb 17 14:38:35 CST 2018

Total time taken to generate the page: 0.02468 seconds