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 -> Re: ddl help

Re: ddl help

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 31 Oct 2002 18:34:40 +1100
Message-ID: <6W4w9.66455$g9.186431@newsfeeds.bigpond.com> 





Alter tablespace BLAH offline;


c:\> copy dbf1.dbf dbf2.dbf


Alter database datafile rename 'c:\dbf1.dbf' to 'c:\dbf2.dbf';
Alter tablespace BLAH online;



Regards


HJR




"P Schram" <schrammie_at_yahoo.com> wrote in message
news:us1ck6jkap5o20_at_corp.supernews.com...


> What are the steps to rename a database file from say dbf1 to dbf2.

Thanks.


>

>

Received on Thu Oct 31 2002 - 01:34:40 CST












Original text of this message













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