export with conditions 
Author Message
 export with conditions
I have to export a part of a table. This table has more then 60.000.000 rows
and I need just for example the last 10.000 rows.

Import with SQLLoader could contain conditions, but is there a possibility
for Export?

It seems to me now, the only way to solve this problem is to write the datas
with spool and select into an txt-file and import this one afterwards with
the SQLLoader. But this takes a lot f time. Is there a more convienent way?

Thx in advance
Kathinka



Wed, 18 Jun 1902 08:00:00 GMT
 export with conditions


Quote:
> I have to export a part of a table. This table has more then 60.000.000
rows
> and I need just for example the last 10.000 rows.

I have forgotten: Version 7.3.4 ...


Wed, 18 Jun 1902 08:00:00 GMT
 export with conditions

Quote:

> I have to export a part of a table.
> This table has more then 60.000.000 rows
> and I need just for example the last 10.000 rows.

I'm using Oracle8i R8.1.5, You can try to find when this was
implemented.

There is an Export Parameter "QUERY" example:
exp scott/tiger tables=emp query=\"where job=\'SALESMAN\' and sal\<160\"

or using parameter file:
  exp user/passw PARFILE=Export_query.txt
where Export_query.txt contains:
  query="where job='SALESMAN' and sal<1600"
  ... and other parameters

Hohbeje B.

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 export with conditions

(if that email address didn't require changing)

Quote:

>I have to export a part of a table. This table has more then 60.000.000 rows
>and I need just for example the last 10.000 rows.

>Import with SQLLoader could contain conditions, but is there a possibility
>for Export?

>It seems to me now, the only way to solve this problem is to write the datas
>with spool and select into an txt-file and import this one afterwards with
>the SQLLoader. But this takes a lot f time. Is there a more convienent way?

>Thx in advance
>Kathinka

You don't mention a version but in Oracle8i release 8.1 you can put a predicate
on an export with the "QUERY=" parameter.

You could CREATE TABLE AS SELECT to get the 10k rows you want and then export
that as well.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st


Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Selecting a perfect match OR ANY met condition of 10 conditions

2. DTS Multiple Condition Workflow Using OR Condition

3. DTS Multiple Condition Workflow Using OR Condition

4. Needing to add a condition based on a condition

5. DTS Export: How to have nulls export as blanks on fixed width export

6. Export to Excel - numbers are exported as text

7. export file problem - how to close/unuse the exported file

8. DTS Export does not export all FK props???

9. exporting database did not export default column values

10. Export problem: "0 rows exported"..

11. EXPORT File Format / Export API

12. export data from 8i using 7.3.4 export utility


 
Powered by phpBB® Forum Software