Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Catastrophic Database Failure -- Deletion of Control and Redo Files

    We recently had a database failure that resulted in data loss after an Oracle 19.3.0.0.0 database had both both its control, and redo log files deleted. Please note that I am not a DBA, but simply an analyst that supports the system that sits on this Oracle database. Any amount o...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Is 'SELECT * FROM :TABLE_NAME;' available?

    Is 'SELECT * FROM :TABLE_NAME;' available?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Restore from Archivelog only

    Hello Sir, I am able to get one scenario to work and that scenario was where I had a VM (server) running Oracle 19c with just 1 table 5 records and I did a backup of the whole VM (disk backup) and now I added a new table in my db with 3 records (ensured db is in Archivelog mode) ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    19c doesn't allow truncation of data that is longer in length of column's char(40) definition

    We have an application that has been written to insert a variable that is char(50) into a column that is defined as char(40). In Oracle 11g (I know this is very old) it would merely truncate the last 10 characters without issue. However, Oracle 19c doesn't allow this and raises a...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    character set of a clob

    According to https://docs.oracle.com/database/121/SQLRF/functions100.htm#SQLRF00658 the length function should work on a clob and on a varchar2, returning the length of a string in characters, as defined by the input character set. Could you explain why the length of the same str...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report