I am using Oracle 9.2.0.5 on HP UNIX 11i
I have a shell script:
sqlplus << !
set echo on;

http://groups.google.com/group/OracleMadeSimple
Excellent place for Beginners ...
Download the $29.99 Book (Complete 400, PDF) for FREE exclusively for
this group members ...

Hello, for performance testing, I need to create over 100,000 tables in
oracle.
One problem is, creating that many tables takes a very long time, and
I'm wondering if there was a way I can speed up the creation?

Recently,For new project's reason.I have to learn some Oracle SQL.Since
I think example is the best way for self learning.I looked at the books
on Amazon.But to my confuse,I found two books are very similar,one is
"Oracle PL/SQL by Example" by Benjamin Rosenzweig, Elena Silvestrova

I am ready to build a 2-Node RAC using 10gR2,  and this time it's going
to be 64-bit Linux.  The hardware options are AMD opteron 64-bit or HP
Itanium.  Is there anyone who has gone through the
evaluation/implementation process that can help me make a "better"

Hi,all
Environment: HPUX11.11 ORACLE9i
I wrote a test program,just like lines below:
/*********************************/

This is a newbie question so please don't be too annoyed if the
question is trivial or the method I'm using is inefficient. I'm keen to
learn!
I've written PL/SQL which gets a lists of values into a cursor. That

I have a Oracle 9.2.0.5.0 db with COMPATIBLE = 9.2.0.7.0 ???
This can only be changed manually, no ?

Is there any way to bypass a database startup trigger?
What if someone inadvertently codes something in a startup trigger
which causes problems? Like (silly example, but just to make the point)
invokes an infinite loop or grabs absurd amounts of server resources?

I'm working with 8i on XP.
I downloaded some sample code from otn that shows how to pass multiple ref
cursors from a sp using VB.  The sample uses OraOLEDB.Oracle provider.  When
I try to connect using that provider I get the message "Provider cannot be

Table 1  - source  -  UNPARTITIONED  Very big table > 200M
----------
col1  timestamp with local time zone,
col2      number,

RDBMS Version: 10.1.0.2.0
Operating System and Version: HP-UX B.11.23 U ia64
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Oracle JVM

  i have a question about Tom's new book "Expert one-on-one Oracle".
In Chapter 2, when talk about data files in Oracle system, tom said
that the data block structure have a "block header", it has a table
directory which " The table directory, if present, contains information

I have run the SQL "drop tablespace undotbs2 including contents and
datafiles" sucessfully, but I can find this file in OS folder still
,why? Furthermore, when I delete this file in OS folder by manual, it
shows error message "the file is using, cannot be deleted". Who can

                i have report in report 6i, i made the modification by
creating a custome table and dumping data into it from earlier query by
inserting and updating data from formula coloumns. Then I am selecting
the data from the table and sorting it by a coloumn and deleteing ...