I am using TOAD to organize my Oracle Test database. I created a new
user and know want to assign to this user some tables and views like
dba_segments, etc. How can I do this?
Thanks for your help,

As has been noted on here a couple of times, if you want to use the web
plsql toolkit to generate xhtml-compliant tags (e.g. all lower case)
then one option is to copy the HTP and HTF packages and edit these (the
source is not wrapped).

There is a measurement data which storing some measurement values.
Now i want to write a trigger on this to achive following goal.
insert in a history table if the measurement.DataValue is increase by
some predefine value. also insert the time for this.

I am trying to write an Anonymous block that will return a cursor so
that I can run this SQL via ODBC and it will return a recordset.  I am
unfamiliar with how I should declare this function so that it will be
recognised ... at the moment I get an error saying: "'SP_GET_CURSOR' is

someone could tel me how can i do to see if my database is in spfile
or in pfile mode ?
Thanks

DatabaseMetaData.getColumns() returns 0 fileds when create a synonym
on?
Hi, There.
I met this problem:

On a Solaris 8 system running Oracle 9i (9.2.0.6) Enterprise Edition we
are considering Advanced Replication.  We basically need to replicate
all the user schema objects in the database. After wading through the
docs I have a few questions.

Need help!!! I am writing an sp that uses a cursor to get the rowid and
it passes as upper case. Is there a way to get the cursor to preserve
the case?
Thanks,

A client has given us a project that will include working on their oracle
database.
We could write a tools to achieve what we need but Oracle might already have
such software.

while reading Fundamentals certification guide,  i read the following
question.
while shutdown option will waits for users to complete their
uncommitted transactions?

I am setting up a new database that will soon be in use. (Oracle
10.2.0.2.0, Windows 2003).
I read some security articles that recommend changing the default
LISTENER port to something besides 1521. I decided this sounds like a

From the time I upgraded to 10gr2 on SPARC SOL9, I have run into oracle
process hitting the ceiling in processor usage when developer
applications such as MS Access or reporting programs like Crystal
Reports accesses catalog related info such as column names and types

I'm trying to do a clone and getting these errors. Any Suggestions ?
Oracle 8.1.6 on HPUX / HP Dataprotector. I have created the soft link
as
ln -s /opt/omni/lib/libob2oracle8.sl $ORACLE_HOME/lib/libobk.sl

I have to insert 32 million records and i have pasted the script below
that i am using. It is taking a considerable amount of time and wanted
to know if there was a way to make it faster.
Thanks

I am using Oracle 9.2.0.5 on HP UNIX 11. I am using following query:
select sid, sql_address from v$session order by sid;
I only get one sql_address for each session id. I am assuming this is
the sql address of current or last  sql statement run by this