[Gusdev-gusdev] instance v's schemas

[pjm <pj...@sa...>]

Jonathan,

we have always had a serate instance for testing and development in production
software - quite handy when some dodgy SQL brings the server to its knees. The
only thing in the code that changes is the connection to the DB itself, nothing
else. Does Oracle run on just the one machine?

We have scripts to dump data (all or a subset) from the live DB into the test
one so we have working real data.

As for getting the schema into our instance, I am attempting to write a script
that will run as each user to create the nessacery tables and log what happened.
I have also come accross 2 buglets;

the *-indexes.sql just contain line returns or white space, not actual code.

I added this line to core-tableinfo.sql;
        alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';
Oracle 8 & 9 have a default date field of 'DD--MON-RR' I believe.


Paul.