How to use dbms_utility packages
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to use dbms_utility packages

  1. #1
    Join Date
    Oct 2000
    Posts
    449

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    FUNCTION GET_TIME RETURNS NUMBER

    SQL> select dbms_utility.get_time from dual;

    GET_TIME
    ----------
    4527754

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    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

    ~

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    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
  •  



Click Here to Expand Forum to Full Width