Re: exporting part of the table

From: TurkBear <johng_at_mm.com>
Date: Thu, 14 May 1998 15:52:05 GMT
Message-ID: <355b1290.7564126@news2.mm.com>

The only way I know would be to create a temporary table using create table temp_export as select * from orig_table where date_field...

Then export this table ; to use it - import and rename

Hope it helps,
John Greco
Oracle DBA

plevmar_at_my-dejanews.com wrote:

>Hi !
>
>Has anyone ever tried to export just the part of the table ?
>I have a
>table that includes date field and would like to
>export ( and eventually, if
>needed import ) just the data
>within a time interval. How can this be done ?
>
>Any Suggestions ?
>
>Regards,
>MaRkO
>
>Please email suggestions to ;
>Marko.Plevel_at_rd.iskraemeco.si
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu May 14 1998 - 10:52:05 CDT