i have this query:
SELECT count(*)
FROM
 L_VEHICLE,

I need to set password for Database Control.
emctl stop dbconsole
This command will stop database control.
I want to set a password for it, so that it can not be stop without

Will there be a performance impact in insert operations in a table
that has all indexes defined as compressed as opposed to having a
regular non-compressed index. This is in Oracle 10g.
Thanks

oracle 9.2 on win2003serv. Hello! I droped my non-system tablespace. Base in
archivelog mode.How I can restore it, if I have only backup of my tablespace
and logs, and don't have backup of system tablespace?

Dear Intelligence/Friends,
I am Renganathan, PG Graduate in Msc Information Technology,oracle
certified professional, i am working as software developer in FHAPL
TECHNOLOGIES P LTD,

Hi newsgroup,
Is it possible to build a constraint, that ensures, that there are not
more entries in a column, that look like
'Abc   ' -> trim(upper(..))='ABC'

hope someone's listening on a Sunday ..
Oracle V9.2.0.6 on Solaris 8
I'm trying to configure dataguard and setting up the tnsnames.ora for
the primary and standby databases.

Jim Melton has been editor of the international SQL standard since the
1980s. In recent years he's written articles and spoken at conferences
about the future direction of SQL (such as when SQL:2003 integrated
SQL/XML functions). Jim will be speaking at the LinkedData Planet

Usually, what are the reasons why you have to stop and restart the database
?
Perhaps, for somes maintenance like :
- check integrity of the database ?

I did some testing to find an advantage of parallel access on external
tables. I did an Select count(*)  statement
on an external table with around 450.000 records. The table reads the
data from one file.

I am looking for a ORACLE password auditor?
Any suggestions?

Can someone please give me an explanation, or point me to a URL which
has one, of what v$sqlarea.version_count is all about? I understand it
has to do with the # of child cursors for a given SQL in the library
cache, but why would you need more than one cursor? Is that cursor not

we have very big tablespace 300GB containing 300000 tables and we want
to drop them. We don' t need
the contents, so no need to recover them.
What is the fastest way and less load for the DB to drop it? We have

I have one long textfield that contains productinfo where everything
is stored in ALL CAPS. I'd like to convert it to sentence case, that
is, the first letter of each sentence capitalized.
Initcap doesn't quite do the trick since it converts the first