I have an Oracle 10G Enterprise Edition 10.2.0.1.0 with a standard
installation on XP-Pro. Now I detected a strange behaviour. I made a
reproducable example>
create table xx (feld varchar2(32));

Hi...
I have a task that requires me to rename a column. Problem is, I'm on
8i, which does not support column-level renaming.
So the next recourse would be to create another column in the table, or

I'm on 8i on AIX.
My question isn't 8i specific (good thing); but I need to understand
the mechanism by which the CPU patch detects active databases in the
current home before patching that home.

I want to concatenate a string to a colum as I load into the table....
so the file will contain apple.1, but when I use sqlldr to load it as
apple.1@net.com
any ideas?

when i input the following statement error occur:
 select pubid,pubname,TITLE from (publisher natural inner join journal)
group by (pubid) having count(pubid)>1;
error:

I get an Error when I try to create Recovery Catalog in Oracle 9i on
Red Hat Linux 7.2:
Here are the steps I followed to create recovery catalog:
SQL> create tablespace rman_ts datafile

Is it possible to make a logical standby database on HPUX 9.2.0.4 with a VMS 9.2.0.4 database as master?
I'm thinking of endian problems etc. etc.

What difference does it make :
1. I define a column as varchar2(500) and store only 10 bytes
2. I define that column as varchar2(10) .
Any impact on storage / performance ?

Hopefully someone can help me. I have 2 tables and 1 materialized view
which is updated from a different database instance, the materialized
view links the two other tables. So for example
Table_A

Our production is running on vxfs/odm, and we are very happy with it.
We are building a 'test' box, which will run on linux file systems
I understand you don't want to run ext3 in journaling mode for oracle
datafiles/redo..

Can anyone help me with creating a mirror copy of an AS10g application
server, short of reinstalling everything from scratch? I can make
either a dd or an exact copy, but will this work? I know when I queried
my live app server that there were many many locations where the

We're on Solaris 9.2.0.6 and want to migrate our system to Red Hat
Linux 3.0.
The method I used successfully several times before was this:
1. Full SYS export of everything.

I am creating a sample bug tracker (using Oracle 10g db) and i created
a hisotry table to
log the bug history.
The history table contains details like ProblemRecordNo (PRN),

I am setting up a ORACLE 10g_r2 RAC solution.
Environment Details:
- 2 IBM x335 series
- CentOs 4.2

I want to install 'Oracle Database 10g Release 2 (10.2.0.1.0) for
Solaris Operating System (SPARC) (64-bit)' (Enterprise edition) in the
development environment.
The Oracle website says: