Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Same SQL_ID uses sometimes FIXED Baseline and sometimes NO

    Dear AskTom Team, I'm getting crazy wondering why a query with a FIXED baseline runs only sometimes with plan fixed by the baseline. SQL_HANDLE LAST_EXEC FIX REP CREATED ------------------------------ -------- --- --- -------- SQL_1a03d3b9c1fe160c 13.06.24 Y
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    HS ODBC Connection to SQL Server

    I've installed Microsoft's ODBC driver and configured various files in an attempt to create an ODBC connection from my Oracle database to SQL server, but I'm having trouble connecting from SQL Developer. Using the terminal, I can connect to the SQL Server successfully with: isql ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Alter table to include NOT NULL on a LONG datatype column

    Hello, I am trying to figure out why this answer is correct regarding a LONG data type. Here is the question EMP_DETAILS table Name NULL TYPE EMP_ID NOT NULL NUMBER EMP_NAME NOT NULL VARCHAR2(40) EMP_IMAGE LONG What statements ar
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Data movement over DB Link

    Hi Chirs/Connor, Couple of question related to Table data movement from Primary DB to Archival DB. We are having Two DB's - Primary (holding current 2 years of data) Archival (Primary data + historical) We have separate Archival DB using IMP/EXP from Primary DB and delete records...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Things checked with a constraint converted from "enable novalidate" to "enable validate"

    I have a huge partitioned table(about 3TB) that has a constraint(PK) in "enable novalidate" state. I have to alter the state to "enable validate" state. alter table TEST enable validate constraint PK_TEST; The table belongs to the database(exa) in production mode. I'm afraid the
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report