Re: ask one question!

From: MotoX <rat_at_tat.a-tat.com>
Date: Mon, 13 Jul 1998 08:03:42 +0100
Message-ID: <900313342.14561.0.nnrp-10.c2de712e@news.demon.co.uk>

Of course, you can't 'export by tablespace' as such. You have to look in the data dictionary for those objects contained in the tablespace and then export them. Just thought I'd clarify that for the original poster, before he goes off looking for the 'export by tablespace' option in the Oracle Utilities Manual.

MotoX.

Dominic Baines wrote in message <35A5C650.67E46CD9_at_hermes.cam.ac.uk>...
>Why not export the tablespace, drop it, recreate it with the appropriate
>datafiles and then import ?
>
>Dominic Baines
>
>sor wrote:
>
>> Hi:
>> how to drop one of datafiles belonging to the same tablespace?
>> if enter the following command, it would be fail.
>> "alter database datafile filename offline drop;"
>> help! ....
>> --
>> E-Mail : ymy0_at_www.dab.com.tw
>
>
>
Received on Mon Jul 13 1998 - 02:03:42 CDT