Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Install database

    Where may I find the database installer for Windows 32-bit for Oracle 11.2.0.2? I did not find the 11.2.0.2 Windows version, only Linux.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Comparison between ALTER TABLE MOVE ONLINE and DBMS_REDEFINITION

    I need to move online a huge table with BLOBs (around 25 TB) to a new tablespace with bigger block size. Wich method is recommended? Is DBMS_REDEFINITION still the method recommended by oracle? Or is now ALTER TABLE MOVE ONLINE?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Move tablespace for a queue table in 11g

    How to move a queue table into other tablespace in 11g database? Can we shrink queue table in 11g database? The dbms_redefinition is throwing error in moving to other tablespace as can't redefine. My tablespace datafiles are very much fragmented because of this queue table as the...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Creating hierarchy using a parent child table

    hello guys, I'm trying to create hierarchy using a parent child table for analytic view but I'm struggling. the steps: 1. create a attribute dimension using the table --> (id,name,parent_id) (I succeeded but idk the correct way for the parent child hierarchy). 2.create a hierarch...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    plsql gateway procedure on Oracle Autonomous Database

    Ask Tom: I would like to migrate a PL/SQL Web Toolkit application from an on-prem database instance to the Oracle Autonomous Database. I see references to the PL/SQL Gateway via ORDS (I think) in documentation and administration screens but I'm struggling to connect the dots. Mos...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report