I havent been working with oracle servers for some years now. I have been
asked to patch a 8.1.7.4.1 rdbms to the latest patch. I do not have metalink
access. I may get oracle partner access. I have an idle testserver to work
with before attacking the production server :-) And ...

I am able to run select queries on a table through sql and anonymous
pl/sql scripts. But cannot run the same query through a stored
procedure. I get the error 'PL/SQL: ORA-00942: table or view does not
exist'.

I want to copy database instance from one server to another.
Servers configuration:
1) Server from
Red Hat Linux 7.3 and Oracle 8.1.7

Does anyone know a way to do an replication between two machines that
can't talk to each other?
I have two instances on machines that can't talk to each other for
security purposes.  One gets updated by users and the other is used for

how can i use Decode if I want to evaluate an boolean expression?
I want to convert an Access-SQL-Statement using IIF:
    IIf (Val > 100, ID, 9999) As ID
How can I check if Val is bigger then 100 with Decode,

I'm loading a data file into a temp table using SQL Loader.  One of the
columns is a date type field.  However, in the data file there is
sometimes a series of control characters like
'' in the date fields.  This is causing problems as  all those

When the table was set up one of the column names was set to 'OPERATOR'
. How can I use this as a criteria in the where clause?
I can't change the table column name :(
SQL:

All,
I am in the market for a good 10g DBA OCP book.
I was wondering if anyone could give me feedback on the Oracle Database
10g OCP Certification Book that was released by Oracle Press.

http://www.petefinnigan.com/weblog/archives/00000602.htm wrote:
"10/27/2005: "Josh has released a paper about the Oracle password
algorithm"
I saw a few days ago that Josh was going to give a presentation about

Is it possible to use a different character set (e.g. UTF8 instead of
ASCII) for a single schema or is it a global setting for the db instance?
If the latter, is it possible to change the character set for an
existing db instance? How?

I'm using LogMining in 10.1.0.400 database with Oracle.DataAccess.Client.
What might cause the following error:
Oracle.DataAccess.Client.OracleException ORA-01801: date format is too long
for internal buffer    at

Lets say I  have two tables A and B which both have the same columns PK
,col1, col2, col3.
In table A there is only data in col1.The col2 and col3 columns will
updated using the data from Table B (the tables will be joined using

I have an object:
CREATE OR REPLACE TYPE o_societa UNDER object_arc (
       DESCR VARCHAR2(50),
       CONSTRUCTOR FUNCTION o_societa RETURN SELF AS RESULT,

Is it possible to stop odbc connections to an oracle database? Is there
a setting at the Oracle database server level that lets it refuse odbc
connections?  Any ideas?
Thank you.

SELECT  *  FROM A, B;
gives results but
CREATE MATERIALIZED VIEW test
BUILD immediate