Re: ddl help

No. You're wrong. Arrrrgh.

Honestly: what's going on here? What I posted was correct.

As I further posted, in response to the reply, there are exceptions. To say 'if it's SYSTEM' isn't it. That's a short-cut too far. SYSTEM, UNDO, the current default tablespace... none of these can be taken offline.

BUT THAT's NOT WHAT THE ORIGINAL POSTER WAS WORRIED ABOUT.

Can we please try not to nit-pick, but to answer the original question? Or what??

HJR "Pete Sharman" <peter.sharman_at_oracle.com> wrote in message news:aps6th0ut8_at_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 Fri Nov 01 2002 - 04:25:56 CST