Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> What state... to rename datafile

What state... to rename datafile

From: <johna_at_digisys.net>
Date: Wed, 29 Nov 2000 22:55:12 GMT
Message-ID: <9041ge$ohv$1@nnrp1.deja.com> 






Hello,



We are using Oracle8i on NT4, and need to rename a datafile.



I thought I would bounce the datbase. ie do a shutdown (immediate) on
the database, then open it to the "mounted" state.



Then when I run the command "Alter tablespace dog_index rename
datafile1 to datafile2;  I get errors.



This doesn't seem to work though, any ideas why??



Thanks,



John




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Wed Nov 29 2000 - 16:55:12 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US