How to use a wrapper script with cold backups in Oracle
Understanding Oracle cost-based optimizer (CBO) and rule-based optimizer (RBO)
Can we use a single database update trigger for an Oracle database upgrade?
How to rebuild a database to change Oracle block size
Defining Oracle host string vs. host name
How to separate records in Oracle tables according to date
How to choose a Sun server for an Oracle database on Solaris
UNIQUE index vs. PRIMARY KEY constraint to rebuild Oracle indexes and constraints
How to fix drop table and truncate table commands frozen in Oracle 10g
What's the difference between an SQL inner join and equijoin?
Using an SQL SELECT statement from a non-existing table
Using the SQL date function to find aggregate totals by month
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
ORA-19566 error with RMAN backup in Oracle 8i
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?
How to write an SQL query for two foreign keys to the same table
How to create an SQL CHECK constraint for two letters
Tips for derived tables in SQL and using FULL OUTER JOINs
Should we worry about Oracle memory leaks on Windows?
How to delete a partition on the F: drive with Oracle on Windows
What is a staging table, and how is the staging concept used in Oracle?
What could be causing an SQL count 0 with a successful Oracle import?
How to disable Oracle constraints and triggers during an import in 10g
How to configure Oracle DB_BLOCK_SIZE and Solaris operating system block size
How does Oracle instance recovery work and what happens internally?
How to back up Oracle 10g RAC database on an AIX system
Tips for using parameters in an Oracle dump file import
Is a hot backup part of a backup database using RMAN?
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
Can the Oracle database schema be cleared without dropping?
Tips for how to size an Oracle server
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
RMAN catalog backup: One catalog vs. multiple catalogs
Which backup strategy should I use for my Oracle 10g database?
How to complete an Oracle installation on Linux
When to use the Oracle ANALYZE command and how to avoid complications
How to achieve zero downtime for maintenance on the Oracle database
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
Cold backups after SHUTDOWN ABORT
How to restore a database using RMAN to Point in Time
Installing Oracle homes when upgrading
Partitioning a table in Oracle to improve performance
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?
ORA-06550 error when importing a 10.2 dmp file into a 9.2 database
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
Finding a column value inside a user-supplied string
Using BETWEEN with DATETIMEs in SQL
Which normal form is used most?
Update a specific column in a field or row?
ORA-27101 error: shared memory realm does not exist
How to set up a job for an SQL query in Oracle 10g Grid Control
Receiving the ORA-01652 error with no specified tablespace
Why am I getting the ORA-03113 error when trying to refresh a materialized view?
Remote database administration: What to look for in a provider
Why do I have to start my Oracle database manually?
ORA-06550 error when exporting a database
Hot backup when Oracle Database is up
SQL query for co-authored books
Connecting tables in a database
IN list or series of OR conditions?
Querying complex derived tables
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
The USING BACKUP CONTROLFILE clause in Oracle commands
How to use the OPatch Utility in Oracle
Backup and recovery of Oracle 10g with forgotten admin password
Backup and recoveries of Oracle RAC 10gR2
How to recover a control file
Oracle DBA interview questions
SQL for hourly totals for the last 48 hours
Normalizing a crosstab table
LEFT OUTER JOIN to a MIN/MAX row