-
How to use dbms_utility packages
Hi.. I am trying to use get_time package and any other dbms_utility packages to try out, but resulting in errors..
I am logged in as system or other users that has dba privilege.
exec dbms_utility.get_time
OR
exec get_time
results in error, saying function or package is not declared..
Thx, ST2000
-
FUNCTION GET_TIME RETURNS NUMBER
SQL> select dbms_utility.get_time from dual;
GET_TIME
----------
4527754
-
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
~
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|