I can't local login in Oracle Management Server after installation of
Oracle 9.2. Where I can look the right name and status the Oracle
Management Server?
My Database

I just saw a TV advertisement for Oracle Grid on a cable news channel. It is
be marketed as continuous availability solution. How does this differ from
RAC?

Am just about to deploy a new application - one of those 'generic' database
types with very little Oracle specific functionality built in.
There is no referential integrity, and one sequence generator. All referential
integrity is maintained by the (java / JDBC) application.

I found it that you need to hard-code the partition key values in the
where clause for oracle to do partition pruning. If you join tables
together and one of the table has the partition key values in it,
oracle somehow won't prune partitions. Example:

Good morning,
Here is the message:
SQL> connect sys/****** as sysdba
Connected.

We are planning to use Advanced Replication to replicate data from a
9.2.0.6 instance on Solaris 9 to an archive database that is also
9.2.0.6 but the o/s is Solaris 10. My management is concerned about the
difference in the operating systems and have asked me to find out if

Obviously, the ALTER USER statement to change an expired password
works from an existing connection.
But can a user - with an expired password - change his/her password?

I need help understanding whether I should invest in the scenario below
Scenario:
1- I create a table table1, with colmns c1 (varchar32) ,c2 (number),c3
(number), and partition on column c3

I'm having a bit of a problem here. I'm developing a web service client
that should be integrated in pl sql stored procedures.
For certain reasons I want to run the java part on the application
server (because this server has direct access to the internet and the

I am running Oracle 9i (9.2.0.1.0) on Windows XP (development) and
experimenting with the ANSI outer join syntax - and it doesn't seem to
be working!
The queries:

Am just about to deploy a new application - one of those 'generic' database
types with very little Oracle specific functionality built in.
There is no referential integrity, and one sequence generator. All referential
integrity is maintained by the (java / JDBC) application.

I am getting the error
SQL*Loader-128: unable to begin a session
ORA-12705: invalid or unknown NLS parameter value specified
on one production mchine when running sqlldr from a script. It is fine

I have created a BFILE. Most DBMS_LOB functions works. However,
FILEOPEN does not work. Any solution?
Same output from SQLPLUS:
SQL> desc x

i've got a table that's basically:
create table foo
(
 id       number

Instruktor - Specjalista ORACLE
Miejsce pracy: Ca³y kraj
Ref: Oracle
Wymagania: