i want to switch from PHP4/MySQL to PHP4/Oracle. Are there any good
Web-tutorials or Web-Links teaching PHP4/Oracle programming and maybe
also Oracle install on linux/windows for an oracle novice like me :-)
Many thanks for any hint!

I just installed 10.1.0.3 on linux.  What is the conventional location
to stick the software?  On HP I alway put it in /opt/oracle/product...
but on Linux it seems people put stuff in /var.
So my question is: Is there a convention agreed upon for where to place

I am quite familiar with Oracle SQL.  I also know about Java and C (i.e. OOP
procedural language).  I am actually doing server side Java and quite often
need to call stored procedure in Oracle database thru JDBC.  Now I think I
need to know stored procedure in Oracle.  So, which ...

I have a live database, which basically slows down as it's used.  The
current solution is to issue an ALTER TABLE tablename MOVE TABLESPACE
spacename, then ALTER INDEX indexname REBUILD.
This is run every day on about half a dozen of the main tables.  The

One of the Puget Sound Oracle User Group's members, Kent Stroker,
has now built the largest RAC on Mac cluster on the planet, TTBMK.
Pictures of the 5 node cluster can be seen at http://www.psoug.org.
click on RAC on Mac news.

I get ORA-01031: insufficient privileges when connecting as system onto
an Oracle 10G database on Sun Solaris 9 using Enterprise manager on a
Windows Xp PC and get the following error:
ORA-01031: insufficient privileges.

Okay, so here's my dilemma:
I have 5 databases--let's call them A, B, C, D, and E--that have
distinct data (schemaA, schemaB...).  I am trying to "consolidate" all
of my data into a new, single database, F, and then propogate THAT data

I'm working with ORacle 10g on HP-UX 11i. I am relatively new to data
normalization (the previous database I was working with was a complete
nightmare of replicated information) and working with views, so please
bear with my ignorance here.

We are not using RMAN for any backup/recovery purposes. However, now we
are using veritas SAN backup at the moment for trial. Below is part of
the script used by veritas for the backup.
d:\oracle\ora81\bin\rman.exe

All,
Does anyone remember/know where to find the code to flip a table on its
side so that output from a select statement aligns the columns in a
vertical fasion?  I'm looking for a function that I though either

I just installed oracle 10g, and found that for some reason a large
number of strange tables have been created in my schema that I have
not explicitly created; They have names such as:
Hi.

Oracle 8.1.7.4
I am confused by the different namespaces in the Library Cache. I did a
statspack report, and this is what I see:
Library Cache Activity for DB: FSQT  Instance: fsqt

i have a user having execute any procedure priv.Is it some security
issue.
regards

Do you think it would make sense to get:
o at time t(1) the value of v$sql.rows_processed
 and that of v$sysstat.value for name='logical reads'
o then at time t(2) the same figures

Quote fron Steve Adams website - "you need indexes on all the foreign
key columns. Otherwise, you need table locks to be disabled on any
table that is missing a foreign key index"
Assume that table X1 references to X2 and X2 references to X3 and so