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: [Q] how to online drop tempfile???

Re: [Q] how to online drop tempfile???

From: rich <oracle_man_at_yahoo.com>
Date: 13 Sep 2004 14:13:04 -0700
Message-ID: <56f4f26c.0409131313.52f5f3b5@posting.google.com>


Create new temp tablespace.
Drop temp old tablespace.

rich

Mark Bole <makbo_at_pacbell.net> wrote in message news:<d3i1d.18987$6E3.5155_at_newssvr27.news.prodigy.com>...
> Howard J. Rogers wrote:
>
> > Daniel Morgan wrote:
> >>Howard J. Rogers wrote:
> >>
> [...]
> >>>>alter database tempfile '/u01/oradata/xxx/temp03.dbf' drop;
> >>>>alter tablespace temp add tempfile '/u01/oradata/zzz/temp08.dbf';
> >>>
> >>>
> >>>See! I knew I could have looked it up. Did you have to? Or is this piece
> >>>of syntax something now you feel in your bones?
> >>>
> [...]
> >
> > But dropping a data file *at all* has never been possible. Suddenly (well,
> > OK, two versions ago!) we get the ability to drop tempfiles. It just
> > doesn't seem right to me!!
> >
> > As I say, call me old-fashioned!!
> >
> > Regards
> > HJR
> >
> >
>
> I cheated, I looked it (drop tempfile syntax) up in a script I have that
> uses it.
>
> Dropping and adding tempfiles is actually one of the steps for creating
> a logical standby in 9.2. (I'd post a link but access to on-line Oracle
> docs has been broken from my location since yesterday -- 404 page not
> found errors -- but I have an off-line copy). See section 4.2.16 of
> Dataguard Concepts and Administration (9.2).
>
> OT note: I know the consensus on 9i logstdby is that it isn't completely
> suitable for disaster recovery purposes, but (as I've posted previously)
> it can be used effectively for other things like reporting.
>
> --Mark Bole
Received on Mon Sep 13 2004 - 16:13:04 CDT

Original text of this message

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