I've been researching this for two days without little success. I have
an ASP that accesses an Oracle BLOB to extract MS Word documents
(later to include excel, power point, pdf, and text). The document is
stored there via Rational ClearCase.

Is it possible to access two different Oracle databases located on
two separate servers within a tool such as Oracle SQL Developer or
PL/SQL Developer simultaneously?

Trying to use link tables via ODBC using Oracle driver within MS
Access, I received the following error message
1. Within MS Access, ORA-12154: TNS: could not resolve service
name.... Driver's SQLSetConnectAttr failed IM006 0

i have write a sql, but when put it into excution. some problem was
happening...
the sql is like this:
select sth from

Quite some time ago, a former colleague introduced a feature/
capability of Oracle to me where a developer can see how their SQL
statements are processed by the DB... which clauses are evaluated
first, how things are run, orders of operations, etc.  He mentioned

We seem to have bumped into a common issue, and that is that we need
to automate the loading of a few thousand files nightly.
EXTERNAL TABLEs seem not to be the answer, as the files are on other
servers. Both copying the files to the DB server and using an NFS

I'm trying to install 10g (10.1.0.2) on Windows Server 2003.  The OUI
starts, does the requirements checks, all of which pass, then exits. I
can see that it unzips files into the temp directory, but never brings
up the first dialog.  There is no error message on the screen or in

Hi together,
some questions about SQL Developer and how it is working with the
database...
When I open a datatable (tab data), SQLD does a coresponding select on

Hello people,
Just made a fresh Ora10 install, and i get the dreaded ora-01031
insufficient privileges
when i try a connect / as sysdba or a connect sys/change_on_install as

Oracle 9.2
While trying to install the Oracle client on a server, the team got an
error. Searching for this error on google found the following where
someone hit the same error:

Our application will potentially have a few thousand concurrent user.
I know it has been debated many times, but most of the thread are
dated before 2000.  A lot of new things happened on the market these
years.

I am still on Oracle 8.1.6.1 on HP UNIX 11,  I am using RMAN for
backups. We are going to setup a large data warehouse which is
expected to grow to 500GB.  My main concerns is backup times taken by
database backups. Currently, for 20GB database size, full backups take

Is there a way in Oracle SQL to extract the median of the 3 tests (MATH
READING AND WRITING) and
their scores but only using the latest scores and ignoring older scores?
I want to ignore their oldest math score at the bottom etc..

This is for a home PC. I have Microsoft Loopback adapter installed for
use with Oracle 11G for Windows but it block my internet connection. I
have IP address 10.10.10.. etc and the subnet
mask 255 etc. and the host file all of that done correctly. It works

I'm having trouble figure out how to do this and thought that if I
just asked people could show me some best practices and hopefully
point me to some additional reading material.  I've done a bit of sql
but oracle is new to me (we are using oracle 9.? in case it matters)