Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Viewing table partition compression

    Hi tom, I have a table with compression, also have partitions and subpartitions. You can see The create DDL on the below. As you can see all of my objects are compressed or nocompressed. Bu i can't see this information on the all_tables table. Compression ad compress_for is turni...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Rman backup setup

    Hello Tom, I am wondering what is the benefit of using a recovery catalog over a control file? What are some of the decisions one should consider before going either way? Please and thank you
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Unable to use nested tables on my system

    I am using Windows 11 64 bit / Oracle 19c .Everything works fine except when I create a nested table and associate it with my table as a column . I can neither query it nor drop the table . When I query I get a message that the connection to the database was reset and when I try ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Pl/sql procedure freezes while fetching data from dblink

    I encountered inexplicable freezing of pl/sql procedure while trying to fetch and insert data into table, however same operation runs successfully when called with sql query in any IDE. I am trying to realise ETL process in data warehouse database. I need to load data from a remo...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    implicitStatementCacheSize appears to leave open cursors

    Hey Tom, I have a Java application that runs thousands of different types of queries against an Oracle database millions of times. I wanted to save the query preparation time by using the oracle.jdbc.implicitStatementCacheSize JDBC property to cache prepared queries. But I easily...
    #MISC#
    #ACTIONS#

Upcoming Live Sessions

Upcoming Ask TOM Live report