This is my first Database course, and we are going to have two projects in
oracle (which I know nothing about).
The professor suggested
(1) Oracle 9i Programming: A Primer (Paperback)

Is there anything that you can do in the Oracle Universal Installer to
remove the "Starter Database" from the Oracle Home?
I maintain several Linux 8.1.7.4 instances. I'm applying the CPUs to an
old Red Hat 6.2 system, then copying the ORACLE_HOME to several newer

I want to remove a default value. I tried the following statement:
alter table myTable
modify(myColumn default null)
The default value is now removed, but not the definition.

EXCITING OPPURTUNITIES FOR ORACLE ERP PROFESSIONALS AT ACCENTURE
Hi
We are pleased to announce that we have been retained by one of the Big
5

when I log on sql*plus,using this command,it failed
SQL> conn / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

While trying to install Oracle9i Database Release 2 Enterprise/Standard
Edition for Linux x86-64 I get following error
#uname -a
Linux pldmachine 2.6.14 #9 SMP Tue Jan 10 21:17:18 CET 2006 x86_64

Can I ask if there is a good way of wrapping lines of text in PL/SQL?
I'd like to be able to write a function which reads a file and puts the text
contents into a varchar2.  But, I want this to be the body of an email so
I'd like to make sure that the lines wrap so that there is ...

In Oracle 9i I ran an operation that gathered statistics.  It ran for
several hours and I ended up having to break out of it.  The result is
that my TEMP tablespace is full (OEM shows it as full).
Other than bouncing the database how can I have the TEMP tablespace

  It's been a while since I have had to restore an Oracle backup and I'm
having problems finding the information that I need.
I have a 9i release of Oracle running on Windows 2003 (no service packs). I
do on-line backups every night. The user's group is having a beta server set

I have a question about the DBMS_JOB auto-rerun behaviour in an Oracle
8i (8.1.7.4.1) database.
We have a job running that will fail if the job has already been
executed successfully for a user-specified reporting period. When this

Some time ago one of our customers upgraded their oracle-server from 8.1.7.3
to 9.2.0.7. After this upgrade i recieved some calls from them about strange
behauviour when trying to run som upgrades on our application. I traced it
down to be a 'CREATE INDEX' Statement (on an index ...

I've been trying to create a partition at the end of a table & got
ora-14074/ metalink advised I should use the split syntax but I can't
seem to get it to work
Please find enclosed example

How do I create a stored procedure in oracle as a datasource for
crystal report?
I don't want to use "ref cursor". But what is other way to return
something (table) for the crystal report to be able to see it?

Dear folks,
9.2.0.6 Oracle EE / RAC (two nodes) / SunOS 5.9 64 bits...
Application running on it is mainly (70%) OLTP.
query were running fine, all in a sudden we had several performance

Has anyone here ever come across a PL/SQL package called pkg_utils?
What is it, who supplied it, who wrote it?
Thanks in advance,
Colin