Re: ddl help

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 31 Oct 2002 13:21:53 -0800
Message-ID: <aps6th0ut8@drn.newsguy.com>

In article <32d39fb1.0210311142.4bbb57d5_at_posting.google.com>, oratune_at_msn.com says...
>
>No such requirement exists. All that is required is to take the
>tablespace offline and execute the 'ALTER DATABASE DATAFILE RENAME
>...' command AFTER the file has been physically moved or renamed at
>the O/S level. Then bring the tablespace back online with the new
>file name, just as Howard has illustrated.

Except if the file to be renamed is the datafile for the SYSTEM tablespace, that is! :)

Pete
>
>mngong_at_yahoo.com (michael ngong) wrote in message
>news:<ecf365d5.0210310703.1e9888ff_at_posting.google.com>...
>>"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
>>news:<6W4w9.66455$g9.186431_at_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
>> >
>> >
>> Horward
>> I believe the database has to be mounted only but not opened before
>> files can be renamed?
>> Michael Tubuo Ngong

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Oct 31 2002 - 15:21:53 CST