Re: [Gusdev-gusdev] instance v's schemas

[<cra...@SN...>]

Paul-

> 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?

Right, so we could certainly solve the naming problem by requiring that people
who want a second copy of the database set up a different Oracle instance for
it.  And if it doesn't pose an immediate problem for you I'd propose that we
just not worry about the naming question for the time being.

We also have two Oracle instances, one for production and one for development,
running on two separate machines.  However, I was thinking that we might at some
point want to have two copies of GUS 3.0 on the development machine (and perhaps
this is simply not the case.)  We only run one Oracle instance on the development
machine because there's not much point in having two; we have few enough physical
disks that any dodgy SQL on the one instance would most likely affect the other
one too.  I also wanted to keep things as simple as possible in terms of
administration.

> 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;

Sounds great!

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

OK, I'm sure Debbie is already looking into this.

> 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.

That's my fault, sorry.  We use a nonstandard default date format because I found 
the Oracle default too annoying when we were switching from Sybase to Oracle 8i.

Jonathan

-- 
Jonathan Crabtree
Center for Bioinformatics, University of Pennsylvania
1406 Blockley Hall, 423 Guardian Drive Philadelphia, PA 19104-6021
215-573-3115