I can use
    alter session set current_schema=xxx
and then queries such as
    select * from table_name_no_schema

Hi , With 9i and 10g, where can I find documentation or a list of
stored procs/functions (udfs) in oracle, that can be invoked for admin
or other issues by end users.
Thanks

Hi, can anyone tell me what's wrong with this query? I'm trying to
insert values into a table, where a record with 2 of those values
doesn't already exist:
the values for person_id, object_id, person_type and show_profile are

Let's say I want to set up two systems, A.D and B.D
where D is the Internet domain.
Each system supports an Oracle server (9i or possibly
10g).

Does anybody know any software which design oracle db easly?
do not tell me isqlplus please :D
Thanks

I have to install a 9iR2 RAC on HP Itanium (HP-UX 11i v2 B11.23)
platform with MC/Service Guard RAC extension. I have found some
step-by-step installation guides on metalink and HP sites. These are
generally for HP-UX, but not especialy for the Itanium platform.

Hello...
I have a question about querying the last row of a table... actually I
know how to get the last row of a table but what if there's repeating
data inside of it (linked to a foreign key) and I want to get the last

what is the best way to calculate the
miliseconds between two
TIMESTAMP(3) WITH LOCAL TIME ZONE
columns?

I have a question about using the Bfile datatype. I am aware that
Bfiles are read-only and that you must use a stored procedure to write
the file out to the DB server or place it there yourself. My question
is how do you ensure thread safety while doing this? If the Bfile was

MAYDAY !
On thousands of web pages, I read that you have to type "define
_editor=vi" under SQLPLUS to have a vi-like cmd line but it did never
work for me.

Why can I make following query
select 1.foobar from dual
Result is 1.0 (Oracle 10g1 EE, 32 bit Linux)
So why can I use number as a table name (or actually table alias) and

I'm getting about 60ms RTT from our NYC datacenter to our San Jose
datacenter and was wondering if anyone has had any issues with Oracle on
high latency links? We plan to use dataguard across this link, I have not
started to tune the TCP stack yet, was just wondering if this is ...

Hello everyone, here is my question, is it possible to create a DMT
(dictionary managed tablespace) with the segment space management
clause (regardless if it's set to auto or manual). Is segment space
management an applicable feature for DMTs?

Especifically i need the pre compilers of C and Cobolo runing fine...
but im facing an
make: 1254-002 Cannot find a rule to create target
error during install.

Dear Everyone,
Quick question - will the performance of a database deteriorate if the
filesystem nears it's capacity (i.e 99% full).  Or would this make no
difference (i.e the database would perform the same if the filesystem