Ask the Experts
Ask the Experts
-
ORA-2064 error
-
Do I need to back up the online redo log?
I am learning Oracle backup and recovery, and I am confused on whether to back up the online redo log file or not. Continue Reading
-
Splitting an export into two or more .dmp files
-
ORA-12535 error on connecting to database
-
Loading data from CSV file into Oracle table using SQL*Loader
-
Difference between "active-active" and "active-passive" configuration in RAC environments
-
Interpreting TKPROF results
-
Advantage of using "compute statistics" versus "not compute statistics"
-
Language to use for multithreading for datawarehousing ETL
-
Optimal way to transfer data between two tables in two separate schemas
-
Reducing parse time for distributed query
-
Star schema advice for healthcare data warehouse
-
Data warehousing project for large insurance company
-
Determining cause of ORA-00600 error
-
Unknown error codes: ORA-00600, ORA-06544, and ORA-06553
-
Temp tablespace on Oracle 9i not releasing space
-
Incomplete loading of records in Oracle 8.1.6 using SQL*Loader
-
Error on calling a stored procedure with java code
-
ORA-00604 error on SQL level 2 generated on table update
-
ora-12638-Credential retrieval failed problem on Oracle 8.1.7.4.1
-
ora-12541 error message connecting to database through forms builder
-
Error installing Oracle Developer Suite on Windows 98
-
Error installing SAP 4.7 with Oracle 9.2.0
-
Deleting backups using RMAN
How do I use RMAN to delete old backups? Continue Reading
-
Importing FoxPro and Access databases into Oracle
-
Commenting out db_cache_size parameter in spfile
-
Automatic start of database instance with Oracle 8i on Windows 2000 server
-
Errors connecting to database after installing Oracle9i version 9.2.0.1.0 on Windows 2000 server SP4
-
TNS listener service automatically stopped with Oracle 9.2.0.1 on Windows XP
-
Logging user changes in audit trail tables via trigger
-
License issues with Oracle Advanced Security
-
Oracle application server and database server explained
-
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
-
Comparing costs of Oracle on Linux, Unix and Windows
-
Exporting data to .dat file then into another data table
-
Deleting all but one of the duplicate records
-
Are PL/SQL stored procedures multi-threaded?
-
Using hints to force index use in PL/SQL
-
PL/SQL procedures for data extraction taking too long
-
New background process called "cjq"?
-
Repairing a dump file
-
Calling a stored procedure from the same stored procedure
-
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
-
Tools for storage capacity planning
-
Trouble connecting developer 2000 and Oracle 9i Personal Edition
-
Sending reports to clients via utl_smtp
-
FRM-10142 error trying to demo forms locally
-
The current anniversary year (part 2)
-
The current anniversary year (part 1)
-
Oracle error 12541
-
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
-
Shrinking rollback segments for backups
-
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
-
ORA-00942 and export problems on Linux
-
SQL*Plus not running on Windows XP Home edition
-
Getting data from remote 8i database to 9i
-
Using AUM to transition SQL from 8i to 9i
-
Reading an execution plan
-
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
-
ORA-06401 when using SQL*Plus on host computer
-
Can no longer log into database as the sys user
I can no longer log into my database as the sys user. I am getting an "ORA-01017 invalid username/password: logon denied" error. The password has not changed. Continue Reading
-
ORA-01089 when opening the database
-
Recovering 9i database when current online redo log is lost
How can I recover an Oracle 9i database in a 24x7 environment when I lost the current online redo log group? Continue Reading
-
Backing up tablespace without exp80 and imp80
Find out what datafiles you need with these queries before backing up with exp and imp. Continue Reading
-
Overriding optimizer's execution plan
-
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
-
Rebuilding indexes on temp tables
-
Schematics of data warehouse infrastructure
-
Physical sizes of data types
-
ORA-03114 during initializing database step
-
Easy fix when shared memory realm does not exist
-
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
-
Seeing and killing currently running queries
-
Resolving error ORA-01002
-
Fetching data from temporary tables to display reports getting slow
-
Explanation of the different types of indexes
-
INITRANS and MAXTRANS explained
-
User objects created in system tablespace causing problems
-
Using OOAD to design an Oracle database
-
Using a derived table instead of a view
-
Hardware recommendations for a 500 GB database
-
Groups having only one value in a column
-
Can't access pfile
-
Temp file keeps getting larger
-
Denormalization and basic guidelines for database design
-
Enabling the sql_trace parameter
-
Can't find table x$ksppsv