Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    B2B data sharing

    Hi guys,I have a little question on how does B2B data sharing work ?Say I am the department of home affairs and I want to share the data I hold (data that lives into an Oracle db) to others departments of the country.Especially the data about HR.So how to do w
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    INLIST ITERATOR

    Hi Tom, Some questions about the SQL tuning. 1) I found that when using "IN" in the where clause , INLIST ITERATOR is shown on the explain plan in a cost-based database (and using the index correctly, the response is fast). However, no such INLIST ITERATOR
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Oracle magazine PDF

    how to download a free oracle magazine in pdf about getting latest oracle database and it's technology relevant information as like MSDN of microsoft.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Adding transform=oid:n to import using SQL Developer Import Wizard

    Hi,I know how to use transform=oid:n in a CMD box using impdp. Is there a way to add that parameter to the import when using the Datapump Import Wizard in SQL Developer?Thanks.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    CSV scripts worked well with 12c but in 19c, results are differents - spaces are added before and after value !

    Hi all,It's first time post.We are facing a problem in 19c when generating a csv file.In 12c, results were as expected.Spaces are added after or before the content of the column.Please find attached the information about the environment.-- tables structureColu
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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