Ask the Experts

Ask the Experts

• How to use the UNION operator in Oracle to join two similar tables

  Want to use the UNION operator in Oracle? Learn how to do so to join two different tables with the same number of columns and column names.  Continue Reading

• Using BLOB and CLOB datatypes to store, retrieve an image in Oracle 9i

  Expert Brian Peasland explains how to use large objects (LOBs) in Oracle, such as BLOB and CLOB datatypes, to store and retrieve an image greater than 1 GB.  Continue Reading

• How to use V$SESSION in Oracle to see distributed queries

  Learn how to use V$SESSION in Oracle, including the MACHINE column,to find the number of connections or users connected to a particular database link in this tip.  Continue Reading

• RMAN convert command to migrate Oracle from Big Endian to Little Endian

  Want to migrate Oracle from Big Endian to Little Endian? Learn how to do so with the RMAN convert command and Transportable Tablespaces in this expert tip.  Continue Reading

• How to use the TIME column to check Oracle database backup mode

  You can use the TIME column in the V$BACKUP view to check the length of an Oracle backup mode with this sample query from an Oracle expert.  Continue Reading

• Conduct an internal audit before renegotiating unused Oracle licenses

  Oracle licensing expert Scott Rosenberg explains how to conduct an internal audit before renegotiating unused licenses like Hyperion Planning modules, and how to discuss these licenses with Oracle.  Continue Reading

• Do I need a license for SQL Developer Data Modeler in Oracle?

  Do you use SQL Developer Data Modeler? Learn whether you need a Data Modeler license in this tip from an Oracle expert.  Continue Reading

• Understanding VMware server licensing in Oracle Database EE

  Learn how VMware server licensing in Oracle Database EE works, including how to determine the number of processor licenses, in this expert tip.  Continue Reading

• How to use the CREATE SESSION command to track Oracle database logins

  Oracle security expert Brian Peasland explains how to use the CREATE SESSION command in an Oracle audit table to track Oracle user database logins.  Continue Reading

• Can I download DBCA for Oracle Express Edition?

  Understand how to install the DBCA in Oracle 10g Express Edition and why you cannot simply download DBCA in Oracle in this expert tip.  Continue Reading

• Using Oracle Universal Installer to install Oracle with Pro*C

  Learn how to install Oracle with Pro*C using Oracle Universal Installer without reinstalling Oracle in this expert tip.  Continue Reading

• How to export triggers in an Oracle export command

  Are your Oracle triggers not importing after an Oracle export? Learn why in this tip from expert Brian Peasland.  Continue Reading

• How to recreate an Oracle index in a new schema with the CREATE command

  Learn how to recreate an Oracle index in a new schema using the CREATE command with this sample SQL code from an Oracle expert.  Continue Reading

• Defining Oracle database repository vs. information repository

  Oracle expert Brian Peasland explains how to understand the difference between a database repository and an information repository in Oracle.  Continue Reading

• How to precreate Oracle table extents and define extent size

  Oracle expert Brian Peasland explains how to precreate an Oracle table extent size with a new INITIAL extent size after an Oracle import.  Continue Reading