Ask the Experts

Ask the Experts

• Copy Oracle Database but with no data

  One reader asks how he can make a copy of his Oracle Database but not have any data in it, for test purposes.  Continue Reading

• Oracle RAC and distance limitations

  One reader asks what the Oracle RAC distance limitations are for two environments being run in sync.  Continue Reading

• Object privileges in Oracle database security

  A reader asks a question about the GRANT OPTION as it relates to object privileges in Oracle database security.  Continue Reading

• Oracle perpetual license policies

  One reader asks about his company's Oracle software licenses that they want to drop support on, saying that Oracle wants them to discontinue product use altogether.  Continue Reading

• Changing file paths in a recovered Oracle database

  Expert Brian Peasland helps a reader figure out how to successfully remap the file path for a database that had to be recovered from a dead server.  Continue Reading

• Exadata, hybrid columnar compression, and inserts

  One reader asks Oracle Exadata book co-author Rick Greenwald about compression on row-insertion on Exadata.  Continue Reading

• Oracle Exadata and SGA caching

  One reader asks Oracle Exadata book co-author Rick Greenwald about the SGA caching dynamic in Exadata.  Continue Reading

• Cache Fusion for RAC on Exadata

  One reader asks whether Cache Fusion for Oracle RAC is implemented differently on Oracle Exadata compared to other platforms.  Continue Reading

• Purchasing extra licenses despite no software modifications

  Oracle licensing expert Scott Rosenberg answers a reader's question about their adoption of Oracle E-Business Suite.  Continue Reading

• The problem with row-by-row processing in Oracle Database

  One reader asks what's wrong with his script, and Oracle expert Karen Morton explains the problem with row-by-row processing.  Continue Reading

• Most valuable skill: DBA, PL/SQL or Oracle Forms

  Want to know what skill -- DBA, PL/SQL or Oracle Forms -- is most valued in the IT industry today? Hear from SearchOracle expert Dan Clamage on the topic.  Continue Reading

• Creating lookup tables that support a drop-down menu for categories

  Want to create tables to support drop-down menus for categories in PL/SQL? Learn how in this tip from PL/SQL expert Dan Clamage.  Continue Reading

• Restoring to a backup instance on a backup server for a disaster recovery plan

  In this Oracle database and backup recovery tip, expert Brian Peasland helps a reader restore a backup instance on a backup server in order to develop a disaster recovery plan.  Continue Reading

• Pulling data from a text file to query

  In this SQL tip, expert Karen Morton explains how one can pull data from a text file into a usable format so that it's available for an SQL query.  Continue Reading

• Using the CPU_Count parameter in Oracle partitioning

  Are you allowed to use the CPU_Count parameter in Oracle partitioning? Learn whether this is acceptable in this Q&A from Oracle licensing expert Scott Rosenberg.  Continue Reading