For more information about the site, see the Site Index

• How does the Oracle LGWR write to online redo log files?
• How to join two tables with unique keys in Oracle
• How to restore a dump file with the Oracle SHOW=Y option
• How to perform Oracle database recovery with a corrupt online redo log
• How to use V$SEGMENT_STATISTICS to find the most accessed Oracle table
• Can I create an Oracle Catalog Database with the Enterprise Console?
• Can I install an Oracle client on Windows 7?
• How to use the Oracle Database Upgrade Assistant (DBUA)
• Can I specify Oracle column order in my database table?
• Can I have a single Oracle 11g RAC instance across multiple databases?
• How to use the Oracle export utility to duplicate database structure
• How to perform an Oracle 8i to 10g migration
• Understanding the data archiving definition
• How to choose the primary key columns in an Oracle table
• Can I move the tablespace online with missing datafiles in Oracle?
• Do I need to recreate views after an Oracle table reorg?
• Client-based apps vs. web-based apps in Developer 2000
• Oracle upgrade process vs. Oracle exp/imp for 9i to 10g migration
• Understanding different Oracle development license strategies
• Can I make my Oracle Processor license central for multiple users?
• How to calculate Universal Power Unit license requirements
• How to use RMAN CONVERT to migrate from Solaris to Oracle 11g RHEL
• Do I need new Oracle and Linux licensing to perform Linux testing?
• Migrating Oracle to Sun Solaris with Oracle Transportable Tablespaces
• Can I load Oracle 8 on Windows Server 2003?
• Oracle error 6550 may mean incorrect Oracle export version
• How to plan Oracle Grid Control Repository maintenance
• Why am I having trouble installing Oracle 10g on Vista?
• What Linux flavor should I use for my Linux proof of concept in Oracle?
• How to use DBMS_CRYPTO package for Oracle password encryption/hashing
• How to decrypt an Oracle password using John the Ripper and checkpwd
• How to use the Oracle import utility when importing a dump file
• Are we getting the ORA-00382 error because we're at maximum block size?
• Why does the archive log in Oracle give me the ORA-16032 error?
• When to use the WHERE parameter with the Oracle export utility
• Using the Oracle C++ Call Interface (OCCI)
• How to avoid invalid objects in Oracle and modify during off hours
• Traditional table vs. Index Organized Table (IOT) in Oracle
• RMAN convert command to migrate Oracle from Big Endian to Little Endian
• How to use V$SESSION in Oracle to see distributed queries
• How to use the TIME column to check Oracle database backup mode
• How to use the UNION operator in Oracle to join two similar tables
• Using BLOB and CLOB datatypes to store, retrieve an image in Oracle 9i
• Conduct an internal audit before renegotiating unused Oracle licenses
• Understanding VMware server licensing in Oracle Database EE
• Do I need a license for SQL Developer Data Modeler in Oracle?
• How to use the CREATE SESSION command to track Oracle database logins
• Can I download DBCA for Oracle Express Edition?
• How to export triggers in an Oracle export command
• How to precreate Oracle table extents and define extent size
• How to recreate an Oracle index in a new schema with the CREATE command
• Defining Oracle database repository vs. information repository
• Using Oracle Universal Installer to install Oracle with Pro*C
• Do I need to buy an Oracle license for a development database?
• How to avoid invalid objects in Oracle when restoring the database
• How to perform an Oracle 9i upgrade with the Database Upgrade Assistant
• How to trim the Oracle listener log in Unix/Linux
• How to troubleshoot Oracle critical patch updates using OPatch
• Can I automate Oracle patching when installing Oracle Standard Edition?
• ORA-12514 error when connecting to the Oracle database through Toad
• Solving the ORA-00904 error: invalid identifier in Oracle
• Can I create multiple schemas in Oracle for one user?
• How to avoid Oracle error ORA-00060 when dropping a datafile in Oracle 10g
• How to precreate tablespaces in Oracle before a new database import
• How to solve an Oracle import error
• Will queries run slower in a smaller Oracle buffer cache?
• How to use Transportable Tablespaces in Oracle to copy files quickly
• Using a database link to connect two Oracle apps instances
• Is it possible to automate Oracle CPUs for a DoD project?
• How to tune SQL UPDATE statements for an Oracle 10g upgrade
• Working with substitution variables and using EXECUTE IMMEDIATE in PL/SQL
• How to concatenate rows into a single CLOB in PL/SQL
• How to open a ref cursor in a PL/SQL procedure
• Using the SQL GROUP BY clause for counting combinations
• How to use an SQL CASE expression
• How to check SQL query construction with the Mimer Validator
• How to solve an ORA-1555 error in the Oracle testing database
• Three steps to help improve Oracle database security
• Tips for auditing and securing database backups in Oracle
• How to prevent a SQL injection attack in Oracle
• How to use string functions to make an SQL join
• How to sort an SQL UNION query with special ORDER BY sequence
• How do I solve the ORA-00257 error in Oracle?
• How to use Oracle table extents to allocate less disk space
• How to use SQL's POSITION function with substrings
• Using SQL date functions to get totals for last three days
• An SQL solution for a customer order homework problem
• Using CASE in the SQL ORDER BY clause
• How to rebuild a built-in Oracle package body
• Can we use a single database update trigger for an Oracle database upgrade?
• How to rebuild a database to change Oracle block size
• Understanding Oracle cost-based optimizer (CBO) and rule-based optimizer (RBO)
• How to use a wrapper script with cold backups in Oracle
• How to fix drop table and truncate table commands frozen in Oracle 10g
• Defining Oracle host string vs. host name
• How to choose a Sun server for an Oracle database on Solaris
• How to separate records in Oracle tables according to date
• UNIQUE index vs. PRIMARY KEY constraint to rebuild Oracle indexes and constraints
• What's the difference between an SQL inner join and equijoin?
• Using an SQL SELECT statement from a non-existing table



• More