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: how to drop datafile?

Re: how to drop datafile?

From: Ken Chow <kenchowhk_at_yahoo.com>
Date: Wed, 20 Jan 1999 00:13:22 +0800
Message-ID: <782aj2$n9s8@news.asiaonline.net>


Hi,

think of using the export/import method. Before you do it, take full backup.

Ken Chow

steve_young_at_my-dejanews.com wrote in message <780bud$fu7$1_at_nnrp1.dejanews.com>...
>I have a 10GB tablespace consist of 10 1GB datafiles. Each are partially
>filled(from what I see in storage manager). How can I drop one of the
>datafile without losing the data?
>
>Thanx in advance.
>
>Steve
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Jan 19 1999 - 10:13:22 CST

Original text of this message

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