There is actually a fair amount of tuning that can be done on an oracle
database instance. There are init{orasid}.ora configuration files, there
are changes that can be made to tablespaces and more without actually
touching the database schema for the owner of the Spectra tables.
If she has made changes to the indexes then I doubt that information will
stay if a schema is replaced by an export/import
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 31/07/01, 9:37:28 PM, "don braithwaite" <[EMAIL PROTECTED]>
wrote regarding RE: DBA mucking about:
> Well if that really is the case then it's the answer I wanted to hear. I
> told the client that I didn't think that their DBA should be changing
> anything in there. So I imagine all her work was blown away when I
migrated
> everything from our Dev environment to their Dev environment.
> Thanks,
> don
> -----Original Message-----
> From: Darren Tracey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 30, 2001 9:54 PM
> To: Spectra-Talk
> Subject: RE: DBA mucking about
> If you use the Spectra webtop Migrate or Restore functions to move your
> dbases around, be aware that these functions seem to completely remove
the
> Spectra tables in the destination dbase, then recreate them. They aren't
> just cleared then repopulated. I'm no database expert, but I wouldn't
think
> any tweaking your dba might do would survive this kind of treatment.
> Regards
> Darren Tracey
> Web Developer
> Thiess
> Australia
> > -----Original Message-----
> > From: don braithwaite [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, 28 July 2001 11:38 AM
> > To: Spectra-Talk
> > Subject: DBA mucking about
> >
> >
> > I'm not sure if this is going to be an issue for the client
> > or not, but they
> > informed be today that their DBA was into the Oracle database
> > doing some
> > "tuning" to supposedly improve performance. I thought I should see if
> > anyone else has experienced this, and whether it's going to cause them
> > problems.
> >
> > The only immediate problem, and the reason it even came up
> > was the fact that
> > since we're still in development we have the dev environment
> > locally and
> > we've sent them a total backup of our database the two times
> > they've asked
> > for it. I assumed at the time that they were just using it
> > so that they
> > could get the production site ready for us. As it turns out,
> > they also
> > wanted it so that they could get their DBA to look at it.
> > And now that I've
> > sent them a third full backup, their DBA is freaking as she
> > thinks that this
> > is going to wipe out the changes she made to the database.
> >
> > Should she even be in there mucking about? Isn't this a bit
> > dangerous? I
> > wish I had more info to provide as to what exactly she has
> > done, but they
> > are very close mouthed about what they are doing on their
> > end. I guess
> > we'll see once they do a restore of the backup I sent them.
> > I can't imagine
> > that a bunch of wddx files are going to do any damage to any
> > changes that
> > they could have made to the db structure. But then again I
> > wonder if one of
> > the Oracle db errors I spotted today on their test site is due to the
> > changes she made - hmmmm - interesting.
> >
> > Sorry - Just thinking out load a bit here. Was just curious
> > if anyone else
> > has experienced this?
> >
> > don
> >
> > ==> > don braithwaite
> > [EMAIL PROTECTED]
> > http://www3.sympatico.ca/d.braithwaite
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
