Since I applied oracle patch Im getting errors while exporting the
database, I have already re installed the patch and run all the scripts
and about  2 times the catpatch.sql  and still I get the following
errors while exporting any schema, although if I export only 1 table I

I get the following message: "ORA-06502: PL/SQL: numeric or value
error: character string buffer too small" when I run the following
code.
       Dim cmd As New OracleCommand

             Materlized view is not updating data .For the first time
is copies all the entries from table A to B( suppose i m replicating
logs from A to B ) .I have configured it to update the data after 2
minute  but it is not working (dont give any error ) i.e it dont update

Is it possible a query a database other than the one to which one is
currently connected? Specifically, is it possible to do an INSERT INTO
... SELECT across databases?
9ir2 on w2k.

Good Morning Everyone,
Just wanted to share my observation regarding Oracle. If we compare
when Oracle 7  with what we have right now i.e. Oracle 10g. Its
completely evident that many processes that were the headache of a DBA

What type of backup and recovery options are available for 9i?
I cannot log onto the Management Server, so the easy way is not an option
for me right now. Is there a command-line backup process?

Im new to oracle but I do have a background in sql server.
I created a view and attached it as a datasource in Crystal. I can add the
fields to the report, but when I preview the report, I get "ODBC Error
.....   ORA-00904: invalid identifier". I've been looking for a solution for ...

I'm new to Oracle and RMAN & would appreciate any help with this
problem.  My boss wants me to extract the following information from
the backups that use the recovery catalog database:
Client Name

We've just finished migrating from windows 98 to windows XP only to
discover that there are printing issues with Oracle Reports 6i in
Windows XP.  We are using Dot matrix printers to print our invoices (we
have tried several brands - Panasonic KX 1124i, Epson Lx300+)

I am trying to recover a database with a RMAN backup. I only had
control files, i lost all my dbf and redo. When i try to recover i got
this error message:
ORA-00283: recovery session canceled due to errors

I am testing an Oracle Statspack feature and I assumed that snapshot
ids are generated in sequential order 1,2,3...10 etc if the database
instance is not shutdown during that period. Is my assumption correct?

 Here is an example of a SQL query that doesn't work under ORACLE and
it should work. The ORACLE version may be is 10g (I should ask our DB
administrator)
First create that view:

Hi, has anyone had any experiance using the Oracle database, express
edition.  I've downloaded it, and installed it, however it does not run.  It
comes up with an error message telling me I can't access the ftp sever.
I've loaded it on to a stand alone laptop.  Any Ideas ?

Whats the latest thought on this - is there any reason NOT to
autoextend?  I'm an old-fashioned guy and so far I've been leaving it
off and resizing when necessary.
Thanks in advance

Smart move, release a small footprint version of Oracle, with the ability to
upgrade.