How to rebuild a database to change Oracle block size
Understanding Oracle cost-based optimizer (CBO) and rule-based optimizer (RBO)
How to rebuild a built-in Oracle package body
UNIQUE index vs. PRIMARY KEY constraint to rebuild Oracle indexes and constraints
How to choose a Sun server for an Oracle database on Solaris
How to fix drop table and truncate table commands frozen in Oracle 10g
Defining Oracle host string vs. host name
How to separate records in Oracle tables according to date
What's the difference between an SQL inner join and equijoin?
Using the SQL date function to find aggregate totals by month
Using an SQL SELECT statement from a non-existing table
ORA-19566 error with RMAN backup in Oracle 8i
How to FTP files in Oracle from an ASM disk to a non-ASM disk
How to complete an Oracle schema import after a full data dmp
Using LEFT OUTER JOIN query to get zero row counts in SQL
How to return multiple values for THEN clause in an SQL CASE expression
Can I concatenate row values in SQL?
Should I try to avoid a LEFT OUTER JOIN in SQL?
Tips for derived tables in SQL and using FULL OUTER JOINs
How to create an SQL CHECK constraint for two letters
How to write an SQL query for two foreign keys to the same table
Should we worry about Oracle memory leaks on Windows?
What could be causing an SQL count 0 with a successful Oracle import?
What is a staging table, and how is the staging concept used in Oracle?
How to delete a partition on the F: drive with Oracle on Windows
How to disable Oracle constraints and triggers during an import in 10g
Is a hot backup part of a backup database using RMAN?
How to configure Oracle DB_BLOCK_SIZE and Solaris operating system block size
Tips for using parameters in an Oracle dump file import
How to back up Oracle 10g RAC database on an AIX system
How does Oracle instance recovery work and what happens internally?
How to return a zero in SQL instead of no row back for a select count
How to write an SQL query using GROUP BY for row analysis
Using nested SQL string functions to find ERP customer values in a table
RMAN catalog backup: One catalog vs. multiple catalogs
Tips for how to size an Oracle server
Can the Oracle database schema be cleared without dropping?
Oracle error 942 when exporting a schema
Increasing Oracle storage capacity by moving to a new storage with minimum downtime
Do DDL statements roll back, and why?
Using Undo Tablespaces vs. rollback segments in Oracle 9i, 10g
Which backup strategy should I use for my Oracle 10g database?
How to complete an Oracle installation on Linux
How to achieve zero downtime for maintenance on the Oracle database
When to use the Oracle ANALYZE command and how to avoid complications
Can I use Oracle FTP for importing data from Oracle 11g into 10g?
Is Linux certification necessary for my job in Oracle?
Business Analyst vs. Data Architect: Who should do the source-to-target mapping?
CASE expressions in the ORDER BY clause
SQL to select rows 1000 through 3000 in a table
The SQL REPLACE function
SQL query to combine rows
Installing Oracle homes when upgrading
Cold backups after SHUTDOWN ABORT
How to restore a database using RMAN to Point in Time
ORA-06550 error when importing a 10.2 dmp file into a 9.2 database
User vs. schema in Oracle
Is there any tool to migrate data from DB2 to Oracle?
Can I populate tables in MS ACCESS and upload to the Oracle server?
I have space in log_arch_dest, so why am I getting the ORA-00257 error?
Does making an Oracle datafile READ ONLY after a backup change the file?
Partitioning a table in Oracle to improve performance
Using exp and imp for Oracle Database when switching platforms
Why am I receiving the ORA-12535 error when using a remote database?
Defining RTO, MTBF and MTTR
Managing temporary tablespace growth in Oracle
Update a specific column in a field or row?
Using BETWEEN with DATETIMEs in SQL
Which normal form is used most?
Finding a column value inside a user-supplied string
ORA-27101 error: shared memory realm does not exist
Receiving the ORA-01652 error with no specified tablespace
Why am I getting the ORA-03113 error when trying to refresh a materialized view?
How to set up a job for an SQL query in Oracle 10g Grid Control
Remote database administration: What to look for in a provider
Hot backup when Oracle Database is up
ORA-06550 error when exporting a database
Why do I have to start my Oracle database manually?
SQL query for co-authored books
Querying complex derived tables
Connecting tables in a database
IN list or series of OR conditions?
What is the difference between a database engineer, architect and administrator?
Changing a NULL column to NOT NULL
SQL string functions
What's the best tape backup strategy for 10g RAC?
How does an INSERT/UPDATE statement behave when executed compared to a SELECT statement?
Can I resize the SYSTEM tablespace?
Can I add multiple datafiles and make use of all the temporary datafiles at the same time?
Why am I getting an Oracle error when issuing the RECOVER DATABASE command?
Checkpoint vs. commit process
Backup and recoveries of Oracle RAC 10gR2
The USING BACKUP CONTROLFILE clause in Oracle commands
Backup and recovery of Oracle 10g with forgotten admin password
How to recover a control file
How to use the OPatch Utility in Oracle
Oracle DBA interview questions
SQL for hourly totals for the last 48 hours
LEFT OUTER JOIN to a MIN/MAX row
Normalizing a crosstab table