Is there a way to determine how many quarters have elapsed between two
dates?  I'm trying to come up with a clever way of doing it, rather
than loops and if statements.
An example is I have a start date of December 31st, 1999.  An end date

I get the following errors when I run tnsping (and lsnrctl)
#tnsping orcldb
TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 13-JUN-2005
07:30:20

Hello Oracle Gurus's
-Required simple and efficient solution
I want to replace part of the string  on some conditions.
here is the small pl/SQL code. Oracle 8,9,10G any one is OK

Version: Oracle 9iR2
If you have job_queue_processes set to e.g. 3 and there are 3 jobs
running under DBMS_JOB, will a call to DBMS_JOB.RUN for a 4th job be
held pending availability of a slot or will it run immediately?

Sorry for the cross-post, I posted this on comp.databases.oracle.misc
but I never know which newsgroup to post to for Oracle Text questions.
This groups seems to be much more active.
I'm using Oracle 9.2.0.5.0.

I've got a rather stupid constraint problem:
There's a table with data on PCB symbols (like "7400" or "Resistor").
Per symbol there's the number of pins on the symbol.
Now, another table is supposed to have as many rows (per symbol)

Please excuse what is, no doubt, a stupid question - I'm having to act
as DBA for the time being...
I need to exp a database from one server and imp it on another.  The
originating server hase 2 Oracle instances running on it, each hosting

I'm using Oracle 9iR2 and will shortly be replicating this system in
Oracle 10G.
I've just started using an Oracle Context index to perform text searches
on quite a large dataset.

I was wondering if anyone is aware if there are any best practices
regarding key management when using Oracle's DBMS_OBFUSCATION_TOOLKIT?
I'm particularly interested in how we can protect the
encryption/decryption key that we would use.

I am a Unix administrator, learning Oracle.  I'd like to have a Perl
script run and collect the Oracle version from numerous servers, all
running HP-UX.
I know that I can log in via sqlplus as the system user and run "SELECT

Folks,
Consider a single machine (Sun V480/Solaris 10) running Oracle 10g.  Two
parties are interested in cooperating (one brings the machine, the other
brings the Oracle license).  Disk space (>500 GB) is more than enough for

Hi NG,
we have to replikate some data between an oracle DB and an application with MS SQL Server.
There is no possibility to load and push the data on the client mashine. We have to replicate the data on the server mashines
directly.

I performed the following under Oracle 10g:
CREATE TABLE TESTER
( COL1                   VARCHAR2(8)    NOT NULL,
 COL2                   VARCHAR2(8)    NULL)

I have an open TAR at oracle for Linux setup. The analyst insists that
RAID1 should not be used with Oracle. This is what this guy says,
really insists and repeat in each answer:
"datafiles should not be placed on a RAID 1 layout."

I've got a 7.3.4.5.0 instance on HP-UX 10.20 that's been workign great fro
years.
Now, some maintenance scripts are failing. Doing a little debuging reveals:
1. The tsaks are failing to allocate space in teh TEMP tablespace.