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

Thread: Search DBMS_OLAP Package

  1. 07-10-2001, 08:19 AM #1
    tomate
    tomate is offline Member
    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

    [email protected]
    If you have no aims, you will never reach a goal !!!
    Reply With Quote Reply With Quote
  2. 07-10-2001, 09:18 AM #2
    amar
    amar is offline Senior Member
    Join Date
    Mar 2001
    Posts
    314
    run:

    ORACLE_HOME/rdbms/admin/dbmssum.sql.

    -amar
    Reply With Quote Reply With Quote
  3. 07-10-2001, 09:23 AM #3
    jmodic
    jmodic is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
  4. 07-10-2001, 09:57 AM #4
    tomate
    tomate is offline Member
    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

    [email protected]
    If you have no aims, you will never reach a goal !!!
    Reply With Quote Reply With Quote
  6. 07-10-2001, 09:59 AM #5
    amar
    amar is offline Senior Member
    Join Date
    Mar 2001
    Posts
    314
    Implement it as "SYS".

    -amar
    Reply With Quote Reply With Quote
  7. 07-10-2001, 10:35 AM #6
    tomate
    tomate is offline Member
    Join Date
    Mar 2001
    Posts
    188
    Thanks for the direct answer.
    Best Regards
    Thomas Schmidt

    [email protected]
    If you have no aims, you will never reach a goal !!!
    Reply With Quote Reply With Quote
  8. 07-10-2001, 10:40 AM #7
    amar
    amar is offline Senior Member
    Join Date
    Mar 2001
    Posts
    314


    -amar
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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