I'm looking for a simple way to produce an valid XML file (with external
DTD) from a table.
A function like:  CreateXMLfile(tablename, dtd_filename, xml_filename);
Or is the only way

i have the following table structure with sample data
TranxID       RowID     Table       Description         NewValue
OldValue
1000          1         Table1      IDX                 1

HI
I have a  DBMS_JOB.SUBMIT that will run a proc to delete records. I ran
the submit and all went well.
It did delete all the records I wanted. I had the COMMIT statement

I downloaded and installed the Oracle 10g database
Enterprise Edition for Windows XP on my home computer
back in June, and used in for an online class.
After the class was over, I didn't use it for a while,

we had a database which its nls_characterset was WE8MSWIN1252 so we could
not save non-Latin data there so we reinstall it with AL32UTF8 characterset.
We run a script that creates all structures and procedures and ....But now
when we try to do an insert in a varchar2(30) or ...

LoanAmortizer Professional Edition 3.1
http://www.soft30.com/softdown-1-15874.htm
Loan amortization and payment schedule preparation and printing
application suitable for personal and business use. This is an award

I got the Oracle 10g (10.1.0.4) dbconsole up and running on AIX 5.2 after
much trial & errors (it didn't start out of the box), and I have some
questions regarding the use of it :
- did anyone else had problems on AIX 5.2 ? Is it just my (first) impression

I think i posted in the wrong group before, or maybe no one wants to
answer my question..
I have 5 colummns that are indexed using ctxsys.context. When a user
adds some more information to one of these columns; the columns need to

Platform:  8.1.7 and 9.2.0.1 on various Win2k or Win2003
Last week a developer brought me a query that was running
satisfactorily in prod (8.1.7), but took 45 minutes in test (9.2.0).
As it happens, we are in the middle of transitioning a group of

I am looking for a way(s) to refresh test d/base with data from prod
d/base using RMAN. I am running oracle 9.2 on Win 2003 on both servers.
Could someone share the script, if you have one.
Thanks,

I've got a strange problem. Even after a restart of Oracle (Oracle 10g,
10.1.0.2.0, AIX 5.x) the temp tablespace (8 Gigs in size) remains full
and doesn't seem to be purged. At least this is what the Enterprise
Manager tells me.

Here's my query:
update TRAIN_WORK_EVENT TWE
set    TWE.CURRENT_LOCATION_I = '000805'
where  TWE.TRAIN_I            = 15585

this is the error....
SP_SUBMIT_VALIDATIONS_PURGE is BEING SUBMITTED.
Error running SP_SUBMIT_VALIDATIONS_PURGE -23319 ORA-23319: parameter
value "14-OCT-05" is not appropriate

I have Oracle 10.1.0 installed on RedHat. It came with the Oracle
Enterprise Manager.
I access it with http://servername:5500/em
In this I found a nice integrated backup scheduler and I configured it

Please humour me if this is a stupid question, I've searched through
all of the documentation I can find but nothing seems to be very
comprehensive?!
Is there (anywhere) a step-by-step guide to setting up