Ask the Experts
Ask the Experts
-
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
-
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
-
Errors installing the recovery catalog from RMAN prompt
-
Inserting value that includes single quotes
-
Resolving errors ORA-04091, ORA-06512 and ORA-04088
-
Swapping data of two rows without creating temp fields
-
Explanation of the different types of indexes
-
INITRANS and MAXTRANS explained
-
Can't find table x$ksppsv
-
Database not accessible after IP address change
-
EXP/IMP vs. RMAN for backup
RMAN has many advantages that the logical backup with EXP/IMP cannot provide for you. Continue Reading
-
Importing a dmp file to Access
-
Getting a list of tablespaces
-
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
-
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
-
Composite keys in M:N relationship tables
-
RMAN cold backup vs. hot backup
Why would you want to do an RMAN cold backup vs. hot? What's the difference? Continue Reading
-
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
-
System performance slow after SAP ERP upgrade
-
Changing redo log buffer size
-
Query to retrieve data from past six months
-
Getting a list of all svrmgrl commands
-
Converting number to HEX value, part 1
-
Compilation errors in SQL*Plus stored procedure
-
Correcting a stored procedure
-
Estimating bitmap index sizes
-
Extracting data from .dmp file
-
PL/SQL to display all tables
-
UTL_File to read directories on client machines
-
Inserting and searching many-to-many relationships
-
TOP n WITH TIES in MySQL
-
Cold backup using RMAN
Use this script to perform a cold backup with RMAN. Continue Reading
-
Comparing data from source column with target column
-
Number or float for primary key?
-
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
-
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?
-
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
-
The surrogate key of the row just inserted
-
Cause of ORA-1089 error
-
ODBC vs. SQL*Net security
-
Turning off Local OS Authenticationo
-
Optional foreign key can be NULL
-
Missing right parenthesis
-
Approving multiple invoices in Oracle AP
-
SQL query for parent/child relationship
-
How to send consolidated invoices
-
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
-
Step-by-step backup procedures
Brian Peasland provides step-by-step instructions for performing hot and cold backups. Continue Reading
-
Database Configuration Assistant error after install
-
GROUP BY with two tables, part 2
-
Factors to consider when creating a new database
-
Changing database character set, part 2
-
UTL_SMTP vs. UTL_TCP
-
Understanding autoallocate and segment space management
-
Different types of pragma
-
Adding time using PL/SQL
-
Trying to call SAP BAPI from Oracle Forms
-
Script for SHOW SGA command
-
What is a correlated subquery?
What is subquery and correlated subquery? What is the difference between them? Continue Reading
-
First and last date of the current month
-
Why "select star" is bad
-
Selecting a BLOB column from a table
-
Insufficient privileges error ORA-01039
-
Best size for SORT_AREA_SIZE
-
Importing data from Access to Oracle
-
Viewing data stored in CLOB, part 1
-
Generating unique numbers without using sequence
-
Errors when importing from same version
-
Relating Cartesian product to relational algebra and calculus
-
Creating a dynamic crosstab query with Oracle, part 1
-
Importing/exporting wrapped PL/SQL procedures
-
Counts and total count in one query
-
How to reuse space in Oracle
-
Weighted percentiles, part 1
-
Importing dump file from Oracle on Linux to Oracle on Windows
-
Three consecutive days
-
Gaps in sequences
-
How does RAC handle DML operation in failover?
-
Calling a stored procedure in DB2 from Oracle 8.1.7
-
Two foreign keys to the same primary key?
-
The integers table
-
Oracle Forms Developer script to change Windows resolution
-
Bank statements don't match AP, AR transactions
-
What are modern database management system's applications?
-
How to view report output generated by another user
-
13 steps to replacing small redo log files
-
What is error SP2-0678?
-
26 performance tuning questions and solutions, #1-10
-
What is ORA-06512?
Learn how to solve the ORA-6512 error in this tip on Oracle errors from an expert. Continue Reading
-
Setting up ODBC driver for migration
-
Is RMAN backup smaller than normal OS-level backup?