Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Remove the invalid records

    Hi Tom and Team, I am looking to remove the invalid records before applying PK<code>create table OLD_ABC( PRODUCT, CLASS, SEASON_KEY, DATE, PRICE)KEY -- (PRODUCT, CLASS, SEASON_KEY, DATE)TABLE records -- Ex. ABC , 121 , S ,1-JAN-21, 15 PQR , 1
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Grant Access on DB_Link to other User

    I need to give access to other user on current DB_LINK, can you provide command ?Current Link: sittestGrant to User: Z9XBIQ1_DWRegardsChaudhry
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Hierarchical Aggregation of Columns

    Hello all,Greetings of the new year!Goal - generate an output which can be directly used for pasting hierarchical data into a flat fileLink to liveSQL with sample data and scripts - https://livesql.oracle.com/apex/livesql/s/mw9olr17o7dir21jysn5jni1uExpected ou
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Error using DBMS_MVIEW.EXPLAIN_REWRITE

    Hello All,The problem I raised uses a scenario from one of the quizzes played recently on Devgym.I try to use DBMS_MVIEW.EXPLAIN_REWRITE for a materialized view in LiveSQLand for some reason, I encounter an error for both the table and the array version.- For
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Performance issues in production

    Hi Tom,We are supporting a Siebel application having Oracle 11g as backed. Last month we upgraded database to 19C and after that we are facing performance issues on daily basis. When we checked DB reports like AWR and ASH, I have below observations:a) In AWR r
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more