I am trying to predict the growth of my database every month. Is there
any tool or method which I can use to predict the growth.
Wanted to know whether oracle database only maintains any of these
statistics in the data dictionary.

I'm trying to extract the first ten or twenty records from a table
ordering by date
the sql command is:
1 SELECT *

This SQL works fine in 10g, but no in 8i.
It stops at the subquery highlighting the SUM word, with the error: NOT
a Group Expression.
What is wrong with it. How should I change it.

I'm designing a process to upgrade a large number of customer sites
from 7.3.4 to 10g and would like to know if anyone has any suggestions.
The process will be scripted, non-interactive, and automated (as much
as possible).  The two options seem to be (1) export/import directly

I have created an Oracle Job using the dbms_job.submit package. It is
scheduled to run every night at midnight (trunc(sysdate+1) I am told is
the midnight syntax), it is indeed running successfully every night at
midnight, but it is also creating a new job, with a new job# each time

I had a problem installing oracle on linux as follows:
./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...

I'm working with Oracle 9i and the Web Toolkit, and one of our
requirements for the search page is that the results are limited by a
software parameter (45) for every page. And the end of the results,
there is a list of hotlinks to the pages in the result set. Anyone

I want to identify the port where the net8 listener is running on the
database server.How can i do that ???
Anish

We currently have a 9i Database with OLS and FGAC. The reason for FGAC
is that a user can have multiple roles based on the different OLS
compartments.  They can be view-only on compartment 1, update on 2,
manager on 3...etc.  Also some of the compartments are private so that

This topic has been extensively discussed here and elsewhere, with
respect to database connection.  But what about compiling PL/SQL?
We have a 9.2 database containing PL/SQL that needs to compile against
tables in a 7.x database.  So we have created an 8i 'in between'

I need to conditionally create a tablespace in a script. The idea is
that the user will set a parameter in the script, and the tablespace
will only get created if that parameter contains a given value.
I'm assuming that I need to use PL/SQL to get the necessary IF/THEN

OS: AIX5
RAC: 9204
our purpose: sync a 7*24 production database data to a signle node
database.

I am trying to understand optimal extent sizes when trying to create
tablespaces and tables for 9i and higher.
I created a tablespace with 64k uniform size local managed and segment
space management auto (9.2.0.6 on HP-UX). The database block size is

  When we have an syntax error in SQL issured in sqlplus, sqlplus will
report which line caused this error, does any one know how sqlplus
implement this feature, I think it's a servide feature, how I can
report this error in my program, usually I can only run it and report

Mladen Gogala wrote: