Database Version: 8.1.5.0.0
Granted SELECT_CATALOG_ROLE to user.
07_DICTIONARY_ACCESSIBLITY is default
SQL> select * from v$instance;

I've run into a problem with the merge statement.
Setup:
Each employer may have one or more members.  Each member
has one or more date intervals.

db ver 9.2.0.5
I would like to set a string parameter in another session. An example would
be TRACEFILE_IDENTIFIER.
I know I can set integers and booleans with dbms_system but did not see a

Is there any multithreaded tool like toad, it should be cheaper then it
though

I am studying for my second oracle certified associate test. DBA cert.
Besides self test software, are there any good google groups, websites
or other suggestions to help me get ready for this.
Ryan

what options do we have when we find:
1)An object in sys or system schema is corrupt? -we are in noarchivelog
mode and take only logical backup.
as the object belons to sys/system , we can not drop and recreate

Can anyone tell me if and how you can write what is in the DBMS_OUTPUT
dirctly to  a file using the UTL_FILE using  Oracle 9i?
I have the UTL_FILE set up and working but can't stream information
directly from DBMS_OUTPUT to a file and I was wondering if this is

I have four columns. OBJECTIVES, APPROACH, SCOPE and a TITLE column. I
want the user to be able to pick where he/she wants to search, and to
be able to search two or more of these columns. Example the user checks
off that he/she wants to search the OBJECTIVE and the TITLE column, ...

I am a newbie at Oracle.  I need help figuring out when I run the
following script (createtables.sql) to create tables.  I also included
the errors I am receiving under these scripts.  I am stumped on why
tables are not being created.

I am working on a database on which the temporary tablespace
databfile(1 datafile only) is autoextensible.After executing a large
process the file grew to 9 GB. I added another file to the same
tablespace of size 100M .The new file got 100% filled up (saw it using

I keep getting this error message for my trigger when performing an
insert..select statement (standard plain old insert works):
ORA-04091: table ... is mutating, trigger/function may not see it
The trigger is as follows:

i need make a grant on all table of a user  (oracle 8.1.7) :
grant all on myuser.table1 to public;
grant all on myuser.table2 to public;
grant all on myuser.table3 to public;

      I have been assigned to create a formula  which should compute
the disk size which should be allotted to some database and it should
not fall short for some  period.
Iam calculating the size of the data for that period according to the

I'm new to oracle and am used to Mysql.
I now use oracle because our Remedy application works best with oracle.
I want to create a useraccount in oracle to access the database tables
but I'm not sure how to restrict it.

In sql, we can specify timeout attribute in connection string. In the
similar way , does oracle allow to specify timeour parameter in
connection string?.........If yes then plse let me know the connection
string with timeout attribute.