This one has baffled me for a day now, so I turn to the gurus...
We are testing a (offline) backup script for a Oracle 9.2.0.6 database used
in a W2003 Cluster with Oracle Failsafe. This goes like this (and I'm wide
open for feedback if this is a good way)

I installed oracle 8.1.7 personal oracle into machine  with xp professional
with unicode language set to english..
later i change unicode language to Croatian.(Control Panel/Regional and
Language Options/Advanced/Language for non-unicode programs)

Could anyone pls let me know the diff between table level and column
level constraints as i think constraint applied to column level applies
to table level as well.

while in procedures, I want some columns in a table seperated by "|"
symbol in a variable
take for example emp table
i need ename,job,sal,deptno from emp table in a single string like

Morning all (or afternoon - I'm behind another firewall and using
Google !)
Oracle enterprise : 8.1.7.3 (there's nothing I can do about this I'm
afraid !)

Does anybody here used Oracle 10G ASM?  Is it reliable?  Do you guys
recommend it?
I have two question here.
1) If there is a disk failed in one disk group, how could I tell which disk,

If I understand correctly by setting the following:
alter session set nls_comp=ansi;
alter session set nls_sort=binary_ci;
I can issue a query against the database that is case insensitive.

Hi. Please excuse this question if not on-topic - I'm actually not sure
where to ask it...
I've spent 3 hours searching Oracle's site this morning trying to learn
if they have a web-based application interface that will allow clients

   Bizzare situation, can run the code below perfectly in SQL Plus 8i
but when we try to create a view it generates the 0RA-00933 error
message. Is there anything missing here, and why would SQL Plus be
happy (and fast) but the view complain ?

If we run the statement below
  Select  prd.entry_date, prd.plant_id,
    prd.product_id, prd.unit_id,
    podcommon.gas_conv_eff(prd.plant_id, prd.entry_date,prd.unit_id)

2 questions here...I'm working write not with Oracle 9.2.01
a) I wanted to see the difference between a database instance that is
installed as 'dedicated' v.s. 'shared'. So I installed two instances, choosing
'shared' for one and 'dedicated' for the other. But when I go into ...

I have applicalion, that use OCI v7.
It work very good with Oracle 8.1.7.4.
I install Oracle 10g and rebuild (re-link) my application with
new oracle librarys.

I've installed Oracle10g without any problems and the database server is
running. After shutting down Win XP and starting up the OS Oracle 10g and
listener process is running.
After shutting down the Oracle service and the listener service manually I

I am learning RMAN.
I was reading about RMAN channels on User guide.  It says "An RMAN
channel represents one stream of data to a device type and corresponds
to one server session."  It also says "each

A vendor sent me a TNSNames.ORA file to access their server.  One entry
was production and the other was test.  I was able to TNSPing the
production instance but the test instance failed.
The vendor suggested that I use the Net Configuration Assistant to