Originally posted by st2000
Thanks for your reply pando.. By the way, how would I decode the time.. Is it the time in seconds from 1971 or something..

Secondly, if i want to analyze entire schema, how would I do it? Should I be writing a select statement like using the get_time?

Thanks, ST2000

~
well I dont know and I dont really care, if I want get time I use sysdate

analyze schema, dbms_stats