What is the impact of placing the Oracle redo logs on a Veritas Quick
I/O enabled file system?
--Thanks,
--Mike Jr.

I had an issue at work which has been bugging me since yesterday, so I
thought I might get some help before my weekend gets ruined.
I was in TOAD logged in to schema_1 which has privileges to read
schema_2

I have two tables TableA and TableB. I have a stored procedure which
runs every morning and based on some logic dumps rows from TableA to
TableB. In Table B there are two additional colums ID and RunID. ID is
a normal sequence applied for all rows. But the RunId should be

Could someone please recommend some SQL to test if a Directory Object
is working?
I have been using EM's (dbconsole) test option but would like to be
able to do this from SQLPlus.

I have two tables TableA and TableB. I have a stored procedure which
runs every morning and based on some logic dumps rows from TableA to
TableB. In Table B there are two additional colums ID and RunID. ID is
a normal sequence applied for all rows. But the RunId should be

Using Oracle 9i
I have to compare a DATE column value with a file last modified date
held on a disk system.
In Java I can use the SimpleDateFormat() which adjusts the file date

Oracle Key Concepts - Make Sure You Know All!
Oracle Key Concepts - Make sure you know all especially before
appearing for Oracle Certification (i.e. to becoming Oracle Certified
Professional or OCP)

Oracle People,
For Oracle 10gR2 installs,
I'm trying to figure out some of the details behind the
ignoreSysPrereqs

Here is what I need to get.
Columns: Id, Name, Program, cost
Data sample:
1, George, Program 1, $10

I have created a procedure to display a table in DBMS_OUTPUT using OWA
package.
PROCEDURE showtable (tablename VARCHAR2)
AS

select * from tmp_autorecharge_work a where  exists
(select l.account_number from tmp_autorecharge_work l where
a.account_number = l.account_number
 group by l.account_number having count(*) > 1)

Below are the first lines of a procedure that shall write a log entry
into a log table. It gets a string of variable length and than cuts it
so it fits into the column. My problem: How to know the maximum size
of the column? With %TYPE I get a variable of the corresponding type,

We have an application that runs with either Oracle or MSDE and I'm
looking for substitutes for the following commands that will be
compatible on both databases: CONCAT(), NVL2(), % wildcard.  I believe
they only currently are supported in Oracle.

Below are the first lines of a procedure that shall write a log entry
into a log table. It gets a string of variable length and than cuts it
so it fits into the column. My problem: How to know the maximum size
of the column? With %TYPE I get a variable of the corresponding type,

I am importing an oracle 7 dump file into a 10g database. I am not
able to know the difference between a snapshot and a materialized
view, in a detailed manner. As in Oracle 7 there were snapshots and
there are materialized views,now a days.