Ask the Experts

Ask the Experts

• Can I specify Oracle column order in my database table?

  Oracle expert Brian Peasland explains whether you can specify Oracle column order in your Oracle database and gives example column order SQL statements in this expert tip.  Continue Reading

• Can I have a single Oracle 11g RAC instance across multiple databases?

  Expert Brian Peasland explains whether you can run multiple Oracle databases in a single Oracle 11g RAC instance and how this differs with MySQL and SQL server databases.  Continue Reading

• How to use the Oracle export utility to duplicate database structure

  Oracle expert Brian Peasland explains how to use the Oracle export utility to duplicate Oracle database structure without duplicating Oracle data in this tip.  Continue Reading

• How to choose the primary key columns in an Oracle table

  Oracle expert Brian Peasland explains how to choose the primary key columns in an Oracle table and how to avoid violating Third Normal Form in this tip.  Continue Reading

• Can I move the tablespace online with missing datafiles in Oracle?

  Does your Oracle database have missing datafiles? Learn whether you can stil move the tablspace online when the database is in noarchivelog mode in this trip from an Oracle expert.  Continue Reading

• How to perform an Oracle 8i to 10g migration

  Oracle expert Brian Peasland explains how to perform an Oracle 8i to 10g migration when moving to Oracle 10g R2 with these step by step migration tips.  Continue Reading

• Understanding the data archiving definition

  What is data archiving? Learn the data archiving definition, including the two main data archiving benefits and reasons for using data archiving tools, in this tip from an Oracle expert.  Continue Reading

• Client-based apps vs. web-based apps in Developer 2000

  Thinking of switching from client-based apps to web-based apps? Learn about client vs. web based apps in Developer 2000 and why you may want to make the switch in this tip from an Oracle expert.  Continue Reading

• Do I need to recreate views after an Oracle table reorg?

  Oracle expert Brian Peasland explains whether you need to recreate views in a table after performing an Oracle table reorg, including what to do with INVALID views, in this tip.  Continue Reading

• Oracle upgrade process vs. Oracle exp/imp for 9i to 10g migration

  Oracle expert Brian Peasland explains the advantages of both the Oracle upgrade process and an Oracle export/import when performing a 9i to 10g migration for a schema in this tip.  Continue Reading

• How to calculate Universal Power Unit license requirements

  Oracle licensing expert Scott Rosenberg explains how to calculate Universal Power license requirements using server processor speed in this expert response.  Continue Reading

• Understanding different Oracle development license strategies

  Oracle licensing expert Scott Rosenberg explains how to plan your Oracle development license strategies, such as how to use the OTN development license, in this expert tip.  Continue Reading

• Can I make my Oracle Processor license central for multiple users?

  Learn whether you can make your Oracle Processor license a central system for multiple users and the benefits of the Oracle processor license metric in this expert tip.  Continue Reading

• Do I need new Oracle and Linux licensing to perform Linux testing?

  Oracle licensing expert Scott Rosenberg explains the licensing requirements for Oracle and Linux licensing when performing Linux testing in Oracle.  Continue Reading

• How to use RMAN CONVERT to migrate from Solaris to Oracle 11g RHEL

  Learn how to migrate Oracle from Solaris to Oracle 11g RHEL with the RMAN CONVERT command in this tip from an Oracle expert.  Continue Reading