I'm deploying EBusiness 11i, for use in a training course.
The intent is to stage the server in a tech support area, test
functionality, and then relocate the server to the training
environment (this is a physical relocation, unfortunately).

I'm looking for a few opinions on an issue we are experiencing.
My company currently uses a 3rd party application. Up until a few
weeks ago this application consisted of Java code and a database layer
that used MySql.

I was wondering if someone could recommend a good utility / macro /
script  that would read an SQL statement on  input and produce the
same statement on output that would be formatted to be easy-to-read.
I.E. Inserting new lines, indentation, ... where appropriate.

Oracle 10g 10.2.0.1, Windows XP
When I use the "Generate Database from Server Model" option in Designer a
file is being generated on my desktop which wasn't being generated before.
The file name is ORATST.TXT and I'd like to turn it off so it doesn't

test please ignore

I am an Oracle DBA learning SQL Server 2000. I used DTS as well as bcp
to
export/improt data. However, they work  one table at a time. I want
to

Hi all, I'm trying to create a new sequence thus:
======================================================
SQL> CREATE SEQUENCE DEVICE_KEY.NextVal
 2   START WITH     1

I an a newcomer to the forums and have a quick question of which I've been
unable to find the answer in the documentation or online.
I am running Oracle 9i and wondered if there was a way to see the SQL select
statement that comprises a particular materialized view?  I have seen ...

Oracle Enterprise Manager 10g Release 10.2.0.1.0
Linux RHEL AS 4.4 (32 bit)
We have two linux servers. Need some ideas on how to setup OMS for
high availability. Any pointers, docs, etc would be helpful.

Any idea why an application would be getting ora-1410 (invalid rowid) on
the trigger below?
CREATE OR REPLACE TRIGGER t_tbl1
 after delete on tbl1

Is it possible somehow to limit the number of job queue processes per
user?  I would like to have user A to be able to have a maximum number
of 5 concurrent jobs and user B only 1 at a given time.
Regards,

Hi all, does somebody have an idea about this qustion?.....
This is my script (for data migation) :
--PH1_LOAD.sql
create or replace view myview2 as

Oracle 10g R 10.2.0.3, Windows 2003 Server
I know if I have a VARCHAR2(50) column and I update it from a 15 character
string to 25 character string that I'll use more storage space in the data
blocks.

I'm working on a Discoverer report (10g) that is required to include
in the result set all parameters provided, even when those parameters
are not found in the target tables; just like having an outer join on
the received parameters.

I have installe Enter Linux from Oracle on my machine.
I have downloaded the zip file and put it in /freeware/
Now installing 10g 10.2.0.1 throws errors:
Please let me know if I m doing something I shouldn't be