Search DBMS_OLAP Package
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Search DBMS_OLAP Package

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    188
    Hi gurus,
    i have a simple question, but first the information you need.
    Our db runs under linux (mandrake 7.x) and our db is Oracle 8.1.7.
    So now where is the file and which name has it to install it.

    Thanks for the help. Do you need more information ask?
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  2. #2
    Join Date
    Mar 2001
    Posts
    314
    run:

    ORACLE_HOME/rdbms/admin/dbmssum.sql.

    -amar

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    And for package body: ORACLE_HOME/rdbms/admin/prvtsum.plb

    Note: DBMS_OLAP is in fact synonym for a package called DBMS_SUMMARY.


    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Mar 2001
    Posts
    188
    As which user must i implemented it.
    For example sys or system or the user which will use the package. i think i must be implemented as sys because there is a puvblic synonym clause.

    Thanks for help
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  5. #5
    Join Date
    Mar 2001
    Posts
    314
    Implement it as "SYS".

    -amar

  6. #6
    Join Date
    Mar 2001
    Posts
    188
    Thanks for the direct answer.
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  7. #7
    Join Date
    Mar 2001
    Posts
    314


    -amar

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