I have created an ASM diskgroup, +DATA, and create some directories
under it by ASMCMD (e.g. oradata, flash_recovery_area etc).
When I try to create a new oracle database by dbca, I choose OMF and
set the Database Area as "+DATA/oradata/", it will report error that

I get error message when I try to use sqlplus to startup my db
remotely: sqlplus sys@xyzdb as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested

Oracle 9i had a limit of 64K-1 partitions per table.  10g increased
that to over a million (1024K-1).  Is it practical to approach that
limit (>500,000 partitions)?  What are the pitfalls?
I'm very aware of partition-elimination and partition-wise joins.

I've installed Oracle trial/demo EE software (Oracle site)  Win XP SP2
computer 2 gigabyte storage without applying  any rotten tricks. (Easy and
basic installation, no pre installation warnings, nothing!). Administrator
of WinXP is in the ora_dba group, allow batch and so on is ...

WE HAVE AN UNRGENT REQUIRMENT OF A SENIOR JAVA CONSULTANT WITH STRONG
UI.
LOCATON: CALIFORNIA BAY AREA
LONG TERM POSITION.

The database service can start, but the listener service can't start
even I manully update the listener.ora file and tnsnames.ora file in
%ORACLE_HOME%\product\10.2.0\server\NETWORK\ADMIN directory.

I have upgrade oracle from 9.2.0.2 to 10.2.0.2 on SunOS.
SQL> alter MATERIALIZED VIEW MVIEWUSER.PCATTYPE compile;
Materialized view altered.
SQL> select status,object_type from dba_objects where

We have an urgent requirement from a direct client so if you have any
consultant then please do let me know. Requirements are mentioned
below:
Positon 1:

Sorry for asking what seems to be an obvious question:
Records are inserted into a table A using
INSERT /*+ APPEND */ into A SELECT * FROM B;
There are indexes on table A, and these indexes are in VALID state

I had this two queries:
select * from table where id = number;
select  /*+ NO_INDEX (table PK_IDX)*/ * from table where id = number;
When query used index no row was returned. Index is on primary key

how can i calculate the maximum amount of bytes that can be occupied
by a table row.
The table might not have any data in it, i'm looking for a calculation
based on the data types used for columns.All i found so far was

I would like to fill a CLOB column in an Oracle table by using a
simple script. Each CLOB value contains a big string. What would be
the best way to insert a CLOB value by a simple INSERT statement?
Thank you,

More a question of curiosity, but did you ever had to undo a CPU
implementation? I've run across shops who
a) never applied CPU's
b) applied them without testing and

Oracle 10.2.0.4
Running in case Insensative mode
ALTER SESSION SET NLS_COMP=LINGUISTIC;
ALTER SESSION SET NLS_SORT=BINARY_CI;

It seems the backup and restore method does not work.