Consider this simplified table structure:
[Books]
ID
TITLE

I'm having a local 9i installation running on WinXP home.
I can start and use SQL*Plus. But trying to connect with PL/SQL
Developer (sort of TOAD) and other tools gives me a 12535.
Now what? Don't have a clue. Could it be something in the tnsnames.ora?

I wish those folks would stop farting around with location
of their docs in otn, it f***s up tahiti no end!
Bloody annoying: every second month or so some moron admin
decides to change file locations and all heck breaks lose

I am trying to write a small occi windows applications. I am using VS Studio
.Net 7 (Windows XP).
I can compile and link my small application:
int _tmain(int argc, _TCHAR* argv[])

I am new to PLSQL.
I declared an index by table:
DECLARE
   TYPE index_by_type IS TABLE OF NUMBER

I am taking a look Object Relational feature of oracle, i.e : object
view. (some says that it is the most useful thing from oracle object
feature).
I still don't find the cases when I can make use of object view.

I have noticed that a column with "raw" datatype may be passed to
substr and substrb functions instead of char table. But, despite
Oracle documentation says that the functions are the same for
single-byte database character set, these functions behave

 I'm trying to improve the performance of a procedure that loads
approximately 300 million records into a table.  Currently the process
is using 'INSERT /*+ APPEND*/ .. INTO SELECT' and takes about 10 hours
to run on 10G.  The select joins about 5 tables, most of which are

I have a supertype and three subtypes, as attached below, how is the
best approach to implement it in Oracle (9i/10g) ?
Thank you for your help,
Krist

<<<
ORA-01466: unable to read data - table definition has changed

I keep seeing this error on one particular box.

Hi, all.
I'm working through RMAN, with the goal of phasing out our current cold
backup scheme.
I'm trying to get incrementals and differentials working, but am

Hello Group,
I was trying to write a script that returns the name of my tables and
the number of records in each table.  This is as close as I can get but
keep getting a "PLS-00201: identifier 'TAB_NAME' must be declared"

  i am trying to monitor the temp tablespace for transactions.
db: oracle 9.2.0.3
temp : 1GB
platform: Win XP.

We use Toad for writing PL/SQL on our Oracle DB.
Toad's SCC API allows for integration with source code control SW.
The problem we see is that to work with source control, every time a
developer works on a procedure, the procedure has to be saved as a

I'm currently preparing for the (first) installation of Oracle 10g on one of
our AIX 5.2 servers.
I'm a bit confused by all the different i/o configurations that are possible