In Oracle 9, I have a table that has the following data:
     Type Level Headcount
     Hired Partner 4
     Hired Manager 2

                Can anyone provide me some docs or link to the New
Features in SQL and PL/SQL in oracle 10g?
I have searched the net but unable to find the exact match.
Any help would be appreciated.

I'm reorganizing my company's network, so all the Oracle servers will be
moved from domain mycompany.com to domain subzone.mycompany.com. IP
addresses will remain the same.
I'm wondering whether I must rename the global database names too, for

Hey guys, sorry to bother you again, but I am coming into a problem
that I don't know how to fix.
I create a table by saying:
create table a (b number);

I am in a situation where I have to move redo logs on a live system
hosted on hp-ux. Is there a way to do this. Any advice will be greatly
appreciated.
Thanks

A sales performance table is like:
create table t1 (period number, rep_id number, member_cnt number,
constraint pk_t1 primary key (period, rep_id));
where member_cnt is the ending number of members for a specific sales

Downloaded OracleXE.exe, after installation could not
get the database home page at http://127.0.0.1:8080/htmldb.
Tried lots of times & tghings, always the same result.
Error is 'Cannot find server or DNS Error' means the server

I'm suddenly receiving an ORA-04092 error when trying to do a complete
refresh of a snapshot.  I haven't had any changes to the database.
Database version: 8.1.7.2
OS: HP-UX 11.0

Hello to all!  This is a great group.  Thanks in advance.
I was wondering if any knows how to trim data (not whitespace) with
external tables in oracle.  I'm getting data from a homegrown app in
the form of flat files.  Fome some columns I do not what length to

I am trying to find out how to uninstall an Oracle8i database instance
on Unix-AIX 4.3.  I do not want to remove the oracle software, just one
of the database instances.  Metalink and OTN have not been of any help.
Does anyone out there have a step-by-step procedure for this?

Group,
I am using Oracle 9206 on windows server 2003.  When I set
remote_login_passwordfile=exclusive, everything works fine, but when I set
remote_login_passwordfile=none, I can not start the database, I got error

I am trying to do the following, and would like to know if anyone else
has either done it before, or know of any reason it will not work.
I am using Oracle 10.1.0.4 and have streams setup for replicating data
to a reporting DB (one way).   There is a large amount of data (80 GB

Hello Partner
Please forward some good Resumes with excellent communication Skills
DBA APPS CONSULTANT
LOCATION: Boise,ID

hi guys...
im preparing for the oca exam on oracle database 10g administration 1.
im starting from scratch, meaning, i dont have any background on
oracle. i have oracle 10g in my laptop running in windows xp pro

I would like to cross reference the code in some forms.
I can convert the forms to .fmt and most of the form structure is quite
clear, but some items are stored in "BLONG" format.  It appears to be an
ascii hex encoding of something, but doing the obvious thing (simply