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