After restoring an old set of statistics using
DBMS_STATS.RESTORE_TABLE_STATS is there a data dictionary view where I
can confirm the date and time of current set of statistics that a table
is currently using?

Is ther a better way to do this?
//Code
UPDATE JDE_INBOUNDRIP
SET JDE_INBOUNDRIP.ITEMNUMBER = (SELECT

I search a very good HOWTO for a complete installation of Oracle 9i R2
onto a Fedora core 4.
All the pre-requisites are OK (OS and ENV)
But I always got error messages about library that can not found or

We need to process some data (using PL/SQL) from Oracle tables and at
the end we need to put the result (2 temporary Oracle tables) into 2
DBF files (composed of the same fields which exist at Oracle tables).
We have found we need to use Java inside PL/SQL... that's ok, but isn't

Oracle 10g
Solaris 10
Sun V480
Is it possible to cause all database objects for a particular schema to be

Could someone tell me what the internal differences are
between DBMS_REFRESH.REFRESH and DBMS_DEFER_SYS.PUSH ?
When you configure the refresh of snapshots *without*
scheduling PUSHes, what does not happen that would happen

Does anyone know how I can link a particular session arising from a
connection pool - back to the client that initiated the session. The
App server uses jvm for setting up a connection pool and users are just
assigned an open connection but when you look in V$SESSION you see none

Background:
===========
We have an Oracle 8i site that has a replicated (standby) database
using the RECOVER MANAGED STANDBY DATABASE command.

When I import a dump-file I get the error:
"IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Partitioning"
The Database does not have partitioning so I want to install this

does anyone know how many columns a single table can have with oracle
version 9i?
regards,
Ingo

RDBMS Version: 10.1.0.3
Operating System and Version: RHEL 3 Update5
Error Number (if applicable): CRS-1006
Product (i.e. SQL*Loader, Import, etc.): CRS

just read in the SQL 9i manual about restrictions while using the DISTINCT
statement. The whole sections reads as follows:
---------------------
SELECT STATEMENT:

Hi. I've spent a number of hours searching Oracle's site trying to
learn if they have a web-based application interface that will allow
users to view certain data statistics - info like types of data
available (e.g., raw data from systems X, Y, and Z), data freshness,

Why the select, no return rows??
SELECT a.myfield
FROM table1 a,
    table2 b,

Hello, the following hierarchical query gives acceptable execution times:
select
  rownum,
  mpr.piva_produttore,