Ask the Experts
Ask the Experts
-
Connecting two database servers with two different host strings
-
Copying views from one database to another
-
Causes of ORA-12571 TNS packet writer failure error
-
ORA-03113 and ORA-24327 errors trying to connect to the database
-
Shrinking the size of the Oracle SYSTEM tablespace
-
Purpose of roll forward and roll backward
What are rolling forward and rolling backward in backup and recovery? Continue Reading
-
Allowing some password change privileges to a user
-
ORA-12801 and ORA-01652 errors on running query
-
Splitting an export into two or more .dmp files
-
ORA-2064 error
-
Difference between "active-active" and "active-passive" configuration in RAC environments
-
Star schema advice for healthcare data warehouse
-
Data warehousing project for large insurance company
-
Unknown error codes: ORA-00600, ORA-06544, and ORA-06553
-
Determining cause of ORA-00600 error
-
ORA-00604 error on SQL level 2 generated on table update
-
TNS listener service automatically stopped with Oracle 9.2.0.1 on Windows XP
-
Using 'consistent=y' in exports
Given that export is now not recommended as a backup mode, what is the effect of the 'consistent=y' parameter when data is exported? Continue Reading
-
Calling a stored procedure from the same stored procedure
-
Exporting data to .dat file then into another data table
-
Are PL/SQL stored procedures multi-threaded?
-
Counts from two tables in one SQL statement
-
DIM-00019 and ORA-12560 when creating new database
-
ORA-03113, ORA-24324 and ORA-01041when trying to start up
-
Counting rows by month name
-
Errors installing the recovery catalog from RMAN prompt
-
RMAN level 0 backup failures: ORA-00235
We are using the RMAN level 0 hot backup process. We invariably have level 0 backup failures during the process. Continue Reading
-
ORA-01089 when opening the database
-
ORA-12514 when trying to create db link
I am having a problem creating a db link. It creates successfully but when I run a test query I get the ORA-12514 error. Continue Reading
-
ORA-04031 in the job queue process
-
Recovering corrupt data file without any backup files
I have a corrupt datafile ("fractured block"), and our backups have turned out to be unusable. Is there any other method of recovery, short of sending the datafile to Oracle? Continue Reading
-
Resolving the ORA-03113 error
I have an Oracle 9i database. I am getting the "ERROR at line 1: ORA-03113: end-of-file on communication channel" error message whenever the client is idle for five minutes. Continue Reading
-
Swapping data of two rows without creating temp fields
-
Procedure for sending attachments via utl_smtp
-
Inserting value that includes single quotes
-
Resolving errors ORA-04091, ORA-06512 and ORA-04088
-
INITRANS and MAXTRANS explained
-
Explanation of the different types of indexes
-
Can't find table x$ksppsv
-
Database not accessible after IP address change
-
Redo log files corrupted
We took a cold backup last week. Unfortunately due to media failure my redo log files are corrupted. I have no backup control file. How can I recover the database? Continue Reading
-
Improving backup speed and uses with RMAN
We want to reduce the time needed to take a daily hot backup with RMAN. How can we speed up this process? Continue Reading
-
EXP/IMP vs. RMAN for backup
RMAN has many advantages that the logical backup with EXP/IMP cannot provide for you. Continue Reading
-
Getting a list of tablespaces
-
Importing a dmp file to Access
-
Composite keys in M:N relationship tables
-
System performance slow after SAP ERP upgrade
-
How does RMAN perform hot backups without shutting down DB?
How are hot backups performed in RMAN without shutting down the database? How are inconsistencies resolved? Continue Reading
-
RMAN cold backup vs. hot backup
Why would you want to do an RMAN cold backup vs. hot? What's the difference? Continue Reading
-
Duplicating from a cold backup using RMAN
-
Oracle9i processes not coming up after install/reboot
-
Changing redo log buffer size
-
PL/SQL to display all tables
-
Correcting a stored procedure
-
Compilation errors in SQL*Plus stored procedure
-
Getting a list of all svrmgrl commands
-
Converting number to HEX value, part 1
-
Extracting data from .dmp file
-
Query to retrieve data from past six months
-
Estimating bitmap index sizes
-
UTL_File to read directories on client machines
-
TOP n WITH TIES in MySQL
-
Inserting and searching many-to-many relationships
-
Comparing data from source column with target column
-
Cold backup using RMAN
Use this script to perform a cold backup with RMAN. Continue Reading
-
Dedicated vs. shared server
What's the difference between dedicated and MTS/Shared Server in Oracle 9i, in terms of architecture and performance in a hybrid database? Continue Reading
-
Public/private synonyms to improve performance
-
Number or float for primary key?
-
How Oracle10g achieves grid computing
Brian Peasland explains the concept of grid computing and how it's achieved in Oracle 10g. Continue Reading
-
What's the future for Oracle DBAs?
-
The surrogate key of the row just inserted
-
Steps for copying a database or schema
Follow these steps to copy an entire database or a schema using Oracle's export and import utilities. Continue Reading
-
Cause of ORA-1089 error
-
Turning off Local OS Authenticationo
-
ODBC vs. SQL*Net security
-
Optional foreign key can be NULL
-
Missing right parenthesis
-
Approving multiple invoices in Oracle AP
-
How to send consolidated invoices
-
SQL query for parent/child relationship
-
Step-by-step backup procedures
Brian Peasland provides step-by-step instructions for performing hot and cold backups. Continue Reading
-
Six questions to determine your backup requirements
Oracle expert Brian Peasland provides the answers to six basic questions you should ask yourself before designing a backup and recovery solution. Continue Reading
-
Using ALTER USER for changing passwords
-
Database Configuration Assistant error after install
-
Changing database character set, part 2
-
Factors to consider when creating a new database
-
GROUP BY with two tables, part 2
-
UTL_SMTP vs. UTL_TCP
-
Understanding autoallocate and segment space management
-
Trying to call SAP BAPI from Oracle Forms
-
Adding time using PL/SQL
-
Different types of pragma
-
Script for SHOW SGA command
-
First and last date of the current month
-
What is a correlated subquery?
What is subquery and correlated subquery? What is the difference between them? Continue Reading