What is the Difference between Dedicated Server Mode and Shared server mode
when I create a database?
How can we know which mode we should choose while creating a database?
Thanks.

I am facing a problem in Oracle 9i on Windows 2003 Enterprise Edition.
I am interacting with the Oracle through Java.. Everything is working
fine.
But sometime it is throwing error like "Ora-12505 TNS Listener not

I'm using Pentium IV 3.0 GHz (HT enabled) with Windows XP (SP2) as my
home pc. I was able to install Oracle 8.1.5 Enterprise Edition for
Windows NT in this machine (perhaps, successfully) . Immediately upon
installing, I was able to login and create a user, and things like

Can we do DDL over DBLink ?
Like alter table exchange partition or trucate table over a dblink.
I am using oracle 8.1.
If not is there any workaround.

Can you recomend a tool (IDE) for Oracle DBAs ?
I know TOAD from quest.com is good a tools.
Any other tools like that with comparisons ?
My requirement is a tool for DBAs not for developers.

Hello !!
I've got a problem with a query,I would like to select some data from "
TbOrder"
table  where  the period date is from  the 01/04/(current year) to 31/March

Friends,
Checkout this new tool that helps in database administration and
development. It's called Guggi-Oracle and is available for free
download at:

Hello!  Wondering if someone can help educate me on the design on query
that i would like to run.
Table A             Table B
ID                     PAR_ID

I'm trying to install Oracle 10.2 R2 for Windows (SE) on a 2-node-
cluster with an HP SAN. The SAN is configured with one extended
partition and three logical drives (24 MB for voting, 102MB for cluster
registry and approx. 350GB for data). Everything prepared as described

After upgrading from 9.2 to 10g I'm not able to connect from another
unix account on AIX. It's OK from within oracle account !
I have set ORACLE_SID, ORACLE_HOME, PATH, chown +rx on new ORACLE_HOME
etc..

First I used this query:
SELECT DISTINCT Field1, Field2 FROM Table;
The results was distinct records. So far so good. Note that Field2 is
DATE datatype.

I have used an existing vb process to supply dates, but I am switching
over to a pure SQL. Below is the previous logic.
Select Case Weekday(Date, vbSunday)
Case Is = 1

I have some files contains the rows of a table, and I can parse the files
and get the values of each collumn for the table, and my task is import the
data into the table. I want to write an application to do this.
What is the most smart way? Can OCI APIs do batch commit?

my select returns leter data
RN230006205
250051321RN
RN. 25 0051321

Oracle 9i (9.2.0.6) on Solaris 8 I want to create some simple web
interfaces into my Oracle 9i database.  I do not want to install a
separate web application (i.e. OAS etc.) if I can avoid it.  I have
never used HTML DB.