and if you need help with data modelling or development dave wendelken is definitely the person to ask. I worked with him a few years ago... he knows what he is doing. > > From: Rachel Carmichael <wisernet100@xxxxxxxxx> > Date: 2004/03/16 Tue PM 04:29:35 EST > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: problem getting rid of an undo tablespace > > sounds like you are on the right track...and asking for help here is a > good start. > > my apologies, I didn't mean to offend you. Some developers/DBAs don't > bother to try to learn on their own, then expect the list to fix > problems... My apologies, you are not one of those. > > > --- david wendelken <davewendelken@xxxxxxxxxxxxx> wrote: > > >You started with several mistaken premises: > > > > >1) that you have to drop a file to change the name > > > > Nope! I didn't start with that assumption at all! > > > > I tried 'alter database rename file <oldname> to <newname>;' > > right at first. Gave me error messages that said it couldn't find > > the file. > > > > There's another command, alter tablespace, that's similar to that one > > and I tried it too. It gave me an invalid filename error. > > > > That led me to believe that the filename was something that oracle > > couldn't handle. > > > > My assumption was that it changed the name of the file IN oracle and > > IN the operating system. > > But it doesn't, you have to change the os filename yourself, and do > > it before the oracle command. > > > > By the time I figured that mistaken assumption out, I had already > > followed prompts by oem to take actions that caused other problems. > > > > >May I gently suggest that a review of the concepts and reference > > guides > > >is in order? > > > > I'm an application developer, not a DBA. We all have to specialize > > somewhere, and DBA work isn't mine. > > I've been digging thru the manuals all day long but I was getting > > caught in some catch-22 situations. > > It's the first time in a long time that I've gotten stuck! That's > > why I asked for help. > > > > > > ---------------------------------------------------------------- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > ---------------------------------------------------------------- > > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > > ----------------------------------------------------------------- > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - More reliable, more storage, less spam > http://mail.yahoo.com > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------