How can I deduce the file number of the following block address:
306184587 ? Where/how is the file number stored ?
Thanks a lot !
Regards,

[Oracle 9i]
Need to detect, in a "before update for each row" trigger, if a
specific column had a value informed on the SQL statement.
Example: Table ZZ with A, B, C columns

I'd like to prepare all my statements before I start collecting data.
However, ExecuteSQL and CreateSLQ both run the statement as soon as they
are called.
Is there any way to create a statement without executing it?

We are in the process of migrating from Oracle 7 on winnt to Oracle 9
on windows 2003 server platform.
I would like to know the following things
1) can we copy the data files of oracle 7on winnt to oracle 9 in

Hi :-),
I hv a TimeStamp field in a table and i want to fetch records tht fall
in between the date range.
i m using VB6 for developing front-end app.

i'm sure you all have seen this but figured i'd share just to be safe.
http://www.tradepub.com/free/orm/
happy holidays

I am being told to create another tablespace for an error that I have been
getting (ORA-01654: unable to extend index SYSADM.OPS_TRANS_IDX1 by 138254
in tablespace SYSTEM ORA-27039: create file failed, file size limit reached
OSD-02067: illegal option specified ORA-27039: create ...

i´m very new to oracle...
how do i trace the sql queries ??
using windows oracle version 8

first our system: Oracle 10.1.0.4 on HP/UX (64 bit), 8GB Ram, 4
processors.
The problem: When I execute a query it takes about 3 seconds when
executing it in parallel. When I specify the hint NOPARALLEL it takes

I have two databases.Both are same.Now I want to compare both databse
by each and every objects like
tables
constraint

I'm experiencing some 'strangeness' from the CBO when running a query
in an Oracle 8i (8.1.7) database.
Before I describe the problem, I'm just going to take some time out to
request that all the Oracle Support-like users of this forum who will

I've got two Dell poweredge 1600SC that I want to use for Oracle RAC
testomg. (Both running Redhat ES 3.0).
I can get my hand on a SCSI Disk Array - U320 with 4 10K disks.
My question, in order to run RAC, can i buy just about any U320 SCSI

10.2 Upgrade Information Utility show this warning :
WARNING: --> Database contains stale optimizer statistics.
.... Refer to the 10g Upgrade Guide for instructions to update
.... statistics prior to upgrading the database.

We're moving a SQL Server database to Oracle. I have difficulty in
converting this update query to PL/SQL. The query involves three tables, and
ran fine in SQL Server. But I just can't figure out how to rewrite it as I'm
totally new to PL/SQL.

I have created a view with some hints ( /*+ index ... etc... /*)
I use this view on a report, with where statement clause.
When I linked the view to another table like this :
select ...