Ask the Experts

Ask the Experts

• How to perform an Oracle 9i upgrade with the Database Upgrade Assistant

  Need to perform an Oracle 9i upgrade with an operating system of Solaris 9? Learn how the Database Upgrade Assistant can help.  Continue Reading

• How to trim the Oracle listener log in Unix/Linux

  Want to trim your Oracle listener log? Oracle expert Brian Peasland explains how to do so in Unix/Linux servers without bouncing the listener.  Continue Reading

• How to avoid invalid objects in Oracle when restoring the database

  Learn how to avoid invalid objects in Oracle when restoring an Oracle database with either a full restore or partial restore in this expert tip.  Continue Reading

• How to troubleshoot Oracle critical patch updates using OPatch

  Read this expert tip on how to troubleshoot Oracle critical patch updates and protect your Oracle data with Oracle Enterprise Manager, OPatch and Oracle Grid Control.  Continue Reading

• Can I create multiple schemas in Oracle for one user?

  Want to create multiple schemas for one user in Oracle? Learn whether it's possible here.  Continue Reading

• ORA-12514 error when connecting to the Oracle database through Toad

  Are you receiving the ORA-12514 error when connecting to Oracle through Toad? Learn how to solve this Oracle error.  Continue Reading

• Solving the ORA-00904 error: invalid identifier in Oracle

  Learn about ORA-00904, an invalid identifier error in Oracle, and how to solve it with this tip from Oracle expert Brian Peasland.  Continue Reading

• Can I automate Oracle patching when installing Oracle Standard Edition?

  Read about whether it's possible to automate patching in Oracle with Oracle Enterprise Manager Grid Control when installing Oracle Standard Edition.  Continue Reading

• How to avoid Oracle error ORA-00060 when dropping a datafile in Oracle 10g

  Learn how to avoid an Oracle error, ORA-00060, when dropping a datafile in Oracle 10g with this tip from an Oracle expert.  Continue Reading

• How to solve an Oracle import error

  Oracle expert Brian Peasland explains how to solve an Oracle import error received after taking a table export and importing it into Oracle 10g.  Continue Reading

• Using a database link to connect two Oracle apps instances

  Oracle expert Brian Peasland explains how to use a database link to connect two Oracle apps instances.  Continue Reading

• How to use Transportable Tablespaces in Oracle to copy files quickly

  Oracle expert Brian Peasland explains how Transportable Tablespaces can be used in Oracle when moving data across to a test environment.  Continue Reading

• How to precreate tablespaces in Oracle before a new database import

  Preparing to import a dump file into a new database? Learn what to do to prepare, including precreating the needed tablespaces.  Continue Reading

• Is it possible to automate Oracle CPUs for a DoD project?

  Oracle security expert Brian Fedorko explains the best way to apply Oracle Critical Patch Updates (CPUs) when working on a DoD project and using remote databases.  Continue Reading

• Will queries run slower in a smaller Oracle buffer cache?

  Oracle expert Brian Peasland explains why Oracle queries run slower in a smaller buffer cache.  Continue Reading