I am looking for a consultant who is comfortable in ETL development
(informatica) with Oracle apps (Oracle 11i), please make sure that he
should have a strong knowledge of both the technologies. Below is the
desired skill set, please let me know your concern.

Hello, I have written this command file:
$ cat create_manager_table.sql
-- TODO: Check if manager table exists already and, if so, prompt
-- user to run the the drop_manager_table.sql script first.

Is it possible to show and HTML page in an Oracle Form ? or the HTML code
will always be compiled only by the BROWSER ?
I hope I was clear.
Thanks..

I am looking for a consultant who is comfortable in ETL development
(informatica) with Oracle apps (Oracle 11i), please make sure that he
should have a strong knowledge of both the technologies. Below is the
desired skill set, please let me know your concern.

Can anyone tell me clearly what is the syntax for using DB Links while
joining tables.
For eg:
I have two DB namely Photos and Testing

I use Oracle Database since version 8i, but I'm new to high
availability, please excuse my basic questions. :-)
I've the following hardware (and I can upgrade it if it's not enough):
Two Dell PowerEdge 1850 servers

I am using this code to transfer data from 1 table to another. Tables
used in this script are juts test tables to test the concept.
Iam not sure whats the problem.
I am using FOR ALL for teh first time.

I have a problem with an application based on Oracle 9i. On startup,
this application reads and caches a lot of tables. The time for loading
has increased substantially over the last weeks, from about 15 minutes
up to 50 minutes.

I am using Oracle 9.2.0.5 on HP UNIX 11i. I have a query which was
taking 5 and half minutes. It uses not in sub query. Explain plan shows
using NESTED LOOP ANTI JOIN. I could not undestand why it was takiing
so nong. I added a HASH_AJ hint to not in subquery and  my time reduced

I have made a test installation of an Oracle 10g database on a host, that I
want to give a new host name and IP number.
I am new to Oracle and can not figure out what to change to make the
database accessible after the renaming. Any hints on how to proceed - e.g.

I have to optimize the below query:
SELECT * FROM mytabledetail
WHERE mytableid = 'MTB01'
and bandwidth=64

I'm trying to create user who'll be able to read only data in all
schemas within database. I tried to grant select only and connect role
to this user - but user is still able to insert data into table and
drop data from tables. Then I granted to him only create session

(I'm new to Cost Based Optimizer)
i have a performance issue on one site and i plan to do the following
to investigate the problem :
- export statistics from my customer's server (no tuning pack available

Thanks to some excellent help here, I've had no problem setting up Oracle XE
& working with it locally (on HP Pro). Now I am trying to connect to it
remotely.
I have installed Oracle Database XE Client on the remote (XP Home) computer

I was wondering if anyone has experience on controlling access to specific
applications for an Oracle database user. Basically, I would like to allow a
database user to access an Oracle database only through the specified
application. The application can be arbitrary (an ...