For more information about the site, see the
Performance tuning questions
Mapping values from 8i to 9i
Way to recover a tablespace without backup
Can I use RMAN to back up a database not running in archive log mode?
Advice on Oracle disaster recovery plan
"Database not mounted" error
How much redo is generated from a hot backup?
Best RMAN script for 9i
Steps for importing an 8i database to a 9i/Linux system
Problems transferring Oracle data after upgrade to XP
SQL ANSI standards and compliance
Multiuser capabilities of MS Access running against Oracle database
What is the VARCHAR2 datatype?
Advice for a beginner studying E-Business Suite
Scripts for checking database config and size
How to estimate database size in Oracle
Can I put two primary keys in one table?
Can a tablespace be online if the db isn't open?
What are rollforward and rollback operations?
Where does the CKPT process write to?
Creating a dblink without using tns_alias
Easy way to migrate from IBM DB2 to newer Oracle database
How to view a list of stored procedures through SQL*Plus?
Error with tnsping
Advantages and disadvantages of table partitioning
What is the repository in Oracle Designer?
"Invalid username/password" error
Accessing a schema for data retrieval only
Primary and standby databases
Are reorganizing procedures still necessary?
Recovering a database without a backup
Developing a parser for recognizing HTML tags
Copying data from a master table to another database
Problems connecting to database after installing Forms
"Connection reset by peer" error
Exporting tables to the main server
Running Oracle 9i and SQL 2000 Server on the same machine
How to run DBUA?
"No listener" error
Problems with listener after installing Oracle 10.1.0.2
Steps for installing Oracle patch 126.96.36.199 on Sunfire
Migrating a 9i database on HPUX to 10g on Linux x86
Help with bitmaps and b-tree indexes
Cloning a 9i database in Windows
Best tool for migrating SQL Server database to Oracle
Is Oracle 10g Personal Edition worth the investment?
Difference between subquery and join
Way to identify which row is being locked
Unable to log in after installing Oracle Client 9i
"Create service error" during installation of 10g
Setting a tablespace other than default
Using sequence numbers for primary keys
Importing a .zl file into an Oracle database/schema
Problem installing 8i on Windows XP
Using date as a primary key
Encountering error while cloning a production database
Which column in tkprof specifies consistent gets?
Cause of access violation while connecting from Forms
Rules for creating efficient queries
No new connections allowed
Button trigger raising exception
Learning to read a STATSPACK report
Determining the space used by particular tables
Help with tkprof report
Finding number of logical reads in a block through tkprof output
Is my table in the buffer pool keep?
WHERE EXISTS ( SELECT NULL... ) revisited
DELETE WHERE NOT EXISTS
DISTINCT with GROUP BY
Match two words in a column
Using Perl scripts to take an incremental data export
Migrating a database to 10g and a new server
Why won't the mount and open happen automatically?
"Aurora assertion failure" error
Listener not responding
Difference in 8i and 9i regarding to_number() function
Impact of migration from 8i to 9i
Migrating a database from an 8.0.5 server to a 9i server
Steps for installing grid on development servers
ORA-01017 error when connecting through Windows XP client
Can I run 64-bit and 32-bit Oracle on the same machine?
ORA-4091 error with trigger
Return only one product per category
ORDER BY ordinal position
Accounts with same rows as a given account
Delete first row by date for each customer
Migrating data from 9i on Unix to 10g on Linux
Cloning a database without changing DBID
Creating a test copy of a production database
Moving database from an NT server to UnixWare
Extracting dump files into text format
Using dblink to access a different server
What is causing the hang during export and startup/shutdown?
Help with export/import feature
Taking a backup with Visual Basic
Recovering lost data with resetlogs
ORA-01033 error when taking backup
Importing a trigger from another schema
Procedure for backing up Oracle9i on Windows 2000 Server
What is the solution of the ORA-03121 error?