I have a Oracle9-Database with internal UTF-8 encoding.
Is it possible to get ISO-8859-1 output using sqlplus?
Thanks!
Christoph

Performance Gurus,
Has anyone a proven technique for reducing "sequential file waits" during
INSERT statements?  Some very large tables, with only one or two indexes are
incurring this wait event (from a SQL trace) and have high buffer gets (from

I cannot guarantee a stable connection of my application to the
database over a long time (a week or longer). I'm told to implement a
test to determine if the connection has broken. In this case I should
try a reconnect.

I have oracle 9.2.0.1
In T.O.A.D i wrote complex query and with option export to flat file (no
delimeter) i generate spec file and i exported data from query into
ascii.txt file.

I want to read files from a directory located outside the Oracle
database server, using a pl/sql procedure. I have tried to do this
operation using utl_file package and java storage procedures, no
chance, it doesn't work.

How can I connect sql server table from oracle ?
I want to copy a table from sql server to oracle.
Something like this.
INSERT INTO ORACLETABLENAME ( BLA )

I need step by step for increase SAP/ORACLE Table GLSP___0 ?
FYI, I used SAP R/3 4.6C and Oracle Ver. 9.2.0.4.0
Regards,
Paul

<INFORMATIONAL>
There is a short item in the July-August issue of Oracle Magazine on
page 24.
</INFORMATIONAL>

Following is the excerpt from an article on Transaction logs under
Checkpoints Heading by Peter Gulutzan
(http://www.dbazine.com/db2/db2-disarticles/gulutzan2)
"Users need recoveries to work faster, so there are times when the DBMS

Oracle’s 9i OCP (Oracle Certified Professional) DBA (Database
Administrator) certification is a mid-level certification for IT
professionals who manage large-scale databases or develop applications
that are used enterprise-wide. The Oracle 9i OCP was introduced in late

I am running Oracle 10.1.0.3 on Windows 2000 server. I installed Oracle
from primary CD (no Companion CD).
1.    When I created a database instance itgdev, I did not see
OracleJobSchedulerITGDEV service in  Start status type (it was in

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Solaris 8.
( Yes I know about 9, 10 etc, but these are vendor apps.)

I want to lock some rows in a table, but I must know these rows are not
accessed(SELECT/UPDATE) by other sessions.
How to know the row is used by other sessions.
Thx.

I'm having a problem with loadjava. I want to load a whole bunch of
jars in the database. All these jars work together to invoke a
webservice that is secured with ws security, ssl certificates, the
whole bunch.

this is a general question about relational databases, not specific to
Oracle (I think), so if there is a better place to ask then please let me
know.
I have a question about constraints/foreign-keys.