Re: Drop datafile

Hi Olivier,

You are right in that Oracle doesn't allow you to export the tablespace. As you surmised what you have to do is export the TABLES in the tablespace. Building a list of the tables so you can use an editor to quickly build an export statement can be done as follows:

	SPOOL table_list
	SELECT table_name FROM all_tables WHERE tablespace_name = 'TBLSP_NAME';
	SPOOL off

Regards

Jerry

Olivier Bercovitz wrote:
>
> Ok, but how you can export a tablespace only without export the full
> database and without precise all the tables of this tablespace ?
> I don't think this option exists.
>
> However thanks for your experience
>
> Regards. Olivier
>
> Gcase79 wrote:
>
> > I tried that before and it didn't work for me. You are
> > better off to export the tablespace and then drop and
> > recreate the tablespace.
 

-- 
Jerry Gitomer		Since I know how to spell DBA I became one. 
jgitomer_at_p3.net