exp/imp with query

[elintrend]

Hi,

Can I use query while perform exp.?
e.g.

query=select u_id from id_lookup where u_id > 5000
(more than 1M records in id_lookup table)
==========
my exp:
FILE=c:\exp\ID_g_05302001_1253.DMP
LOG=c:\exp\LOG\ID_g_05302001_1253..log
FULL=Y
indexes=Y
compress=Y
direct=Y
grants=Y
rows=Y
CONSISTENT=Y
=============

[pando]

userid=icdba/icdba@desa
file=test.dmp
log=export.log
tables=ic_promociones, ic_modelos, ic_unidades
query="where cod_red=2 and cod_age=1689 and cod_prm=1"


you have to export with the owner of the tables

[Chintz]

I do not think you can you can perform a query while doing a export. "Query" is not a parameter for the export utility.

Chintz

[pando]

it is from oracle 8i.......

[Dave_A]

Hmm, looking at your question, there are two possible interpretations of your meaning:

1) Can I use a query to limit the records exported (this has been answered by Pando and Elintrend)

2) Can I run a query in a seperate process, while the export is executing

The answer to that is yes. With the consistent=Y flag, you can even perform database updates etc. while the export is running. The only thing you will have to watch out for is the increased likelihood of the 'snapshot too old' error if you use the database while the export is running (that and the performance hit due to the export of course).

HTH

David.