I don't know if there's a way to do a CTRL-BREAK when SQL-Plus
Worksheet is outputting too-much data (say a million rows, which you
have selected by mistake). What I do now is copy the SQL statement,and
then just close the window and open another one, but that's a pain if

Version 10g R1, RH3u6 Linux, two node RAC, separate oracle homes
When I issue the commands:
login oracle@host1
sqlplus / as sysdba

Last few days we are observing ORA-01843: not a valid month, error
continously.
On startup our Application always sets date format to dd.mm.yyyy format
using

I am a beginner in Oracle DBA.
I need to setup a oracle database for the production Environment.
I have browsed through the net and oracle site.  The basic things to
consider will be

I have a manually created 9i database, and I need to return some information
on it.  I need to show the database name, user datafiles, temporary
datafiles, control files, and logfile groups.  Anyone know how to do this?

I did create a temporary table in Oracle 8i without
any problem.
However, How can I create a temporary table in Oracle 8.0
CREATE GLOBAL TEMPORARY TABLE table

Simple testcase:
-- Step 1
SQL> create table CUSTOMER
  2  (

Im new to databases/Oracle.
Recently I enrolled in an Oracle certification course. The Oracle
course material says that usage of Where clause is preffered as it
avoids a cartesian product (thus overloading the query). One colleague

I can not understand meaning of a sentance, present in Oracle concepts
manual..In the chapter of Native Datatypes, it says:
The length semantics of character datatypes can be measured in bytes or
characters.

Many of us know the issue: You change a stateful package's body (i.e.,
having package variables) and recompile it; when using this package in
the same session where it was instantiated, you will repeatedly receive
the ORA-04061/ORA-04068 error chain ("existing state of packages has

I have a table which contains information regarding widgets.  Each
widget has a Department Number and a Product Number.
I need to query the table for a specific set of widgets...about 100 in
all.

I have two databases: base01 and base02.
base01 often queries base02 through a database link (e.g. : (from
base01) select * from mytable@base02).
One session is created on base01 and an other session is created on

I want to have SSL with my Oracle-Web-Server. It's an very old Version (OAS
3.0)
I have configured SSL exactly - read in the documentation.
But it doesn't work !

I have some small code that looks like this:
sqlplus /nolog <<EOF
  connect / as sysdba
  ALTER SESSION SET CURRENT_SCHEMA=&1

we're using Oracle 10g, in combination with Delphi (7). Application
uses Oracle client dll (oraociei10.dll).
Quick explenation about the structure (All files are on the network):
- A launcher application is started by the client. The launcher