Re: ask one question!

From: Dominic Baines <rdab100_at_hermes.cam.ac.uk>
Date: Mon, 13 Jul 1998 14:14:18 +0100
Message-ID: <35AA0829.260289A7@hermes.cam.ac.uk>

Oops... would have been better to suggest a search by user who have objects in that tablespace, export by users, recreate the tablespace, re-import the data. must have been asleep. Apologies it did need clarifying.

Thanks,

Dominic

MotoX wrote:

> 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 - 08:14:18 CDT