Ask the Experts

Ask the Experts

• Migrating Oracle to Sun Solaris with Oracle Transportable Tablespaces

  Learn how migrating Oracle from an HP-UX operations system to Sun Solaris is best done with Oracle Transportable Tablespaces in this tip from an Oracle expert.  Continue Reading

• Why am I having trouble installing Oracle 10g on Vista?

  Oracle expert Brian Peasland explains why when installing Oracle 10g on Vista, a user is prompted to supply authentication credentials they can't get.  Continue Reading

• What Linux flavor should I use for my Linux proof of concept in Oracle?

  Want to do a Linux proof of concept in Oracle? Read what an Oracle expert has to say about which Linux flavor is best.  Continue Reading

• Can I load Oracle 8 on Windows Server 2003?

  Oracle expert Brian Peasland explains why Oracle 8 will not load on Windows Server 2003 and how to perform an Oracle upgrade in this expert tip.  Continue Reading

• Oracle error 6550 may mean incorrect Oracle export version

  Oracle expert Brian Peasland explains why you might get an Oracle error 6550 when using the wrong Oracle export version in this tip.  Continue Reading

• How to decrypt an Oracle password using John the Ripper and checkpwd

  Learn how to decrypt an Oracle password with Oracle password crackers like John the Ripper and checkpwd in this tip from an Oracle security expert.  Continue Reading

• How to use DBMS_CRYPTO package for Oracle password encryption/hashing

  Oracle security expert Brian Fedorko explains how to perform Oracle password encryption and Oracle password hashing with the DBMS_CRYPTO package in this tip.  Continue Reading

• When to use the WHERE parameter with the Oracle export utility

  Expert Brian Peasland explains how to use the WHERE parameter with the Oracle export utility to take an Oracle backup of data from the last 15 days.  Continue Reading

• Why does the archive log in Oracle give me the ORA-16032 error?

  Oracle expert Brian Peasland explains why you might be getting the ORA-16032 error, including why starting multiple instances with the archive log in Oracle will throw the error.  Continue Reading

• Are we getting the ORA-00382 error because we're at maximum block size?

  Are you receiving the ORA-00382 error when determining Solaris block size? Learn what the maximum block size on Solaris is in this expert tip.  Continue Reading

• How to use the Oracle import utility when importing a dump file

  Oracle expert Brian Peasland explains where to run the Oracle command and use the Oracle import utility to see parameters when importing a dump file.  Continue Reading

• Traditional table vs. Index Organized Table (IOT) in Oracle

  Don't know whether to use a traditional table or an Index Organized Table (IOT) in Oracle? Expert Brian Peasland explains the difference.  Continue Reading

• Using the Oracle C++ Call Interface (OCCI)

  Oracle expert Brian Peasland explains if it is possible to connect C++ applications to an Oracle database with the Oracle C++ Call Interface.  Continue Reading

• How to avoid invalid objects in Oracle and modify during off hours

  Oracle expert Brian Peasland explains how to avoid invalid objects in Oracle and if it is possible to modify objects such as packages and views during working hours.  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