Export of data

[DMina]

Hello people!

I am a bit puzzled here so any help will be much appreciated.
Here is the situation:
I have a query which selects all the data based on a date column. I
need all the data which are
older than 130 days:

select count(*) from mytable where insert_date <= sysdate - 130

Currently the above query gives me a number of 31614 rows

The above data will be candidate for deletion. Before I delete I would
like to export this data.
Here is my parameter file:

userid=myuser/myuser@mydb
file=myfile.dmp
buffer=100000
log=myfile.log
tables=(
mytable
)
GRANTS=y
INDEXES=y
ROWS=y
CONSTRAINTS=n
QUERY='where insert_date<=sysdate - 130'

The export shows me that only 598 rows are exported? Shouldn't I get
31614 rows? Am i missing something here?

Thanks

[Bobiander]

Hi,
I use this parameter but not with single quote here is my example:

QUERY=" where trunc(mvvalor) in (to_date('06.01.2005',
'dd.mm.yyyy'),to_date('11.01.2005', 'dd.mm.yyyy'),to_date('13.01.2005',
'dd.mm.yyyy'),to_date('18.01.2005', 'dd.mm.yyyy'))"

this export works here ...

[DMina]

Hi and thanks for the reply,

I have changed the single quotes to double quotes but still have the
same problem.

any other ideas?
Bobiander wrote:

Hi,
I use this parameter but not with single quote here is my example:

QUERY=" where trunc(mvvalor) in (to_date('06.01.2005',
'dd.mm.yyyy'),to_date('11.01.2005', 'dd.mm.yyyy'),to_date('13.01.2005', 'dd.mm.yyyy'),to_date('18.01.2005', 'dd.mm.yyyy'))"

this export works here ...

[Bobiander]

What is format of insert_date column , may be you must
trunc(insert_date) in where clause , also in my example I have a space
before WHERE , I remembrer that I try few times , before find what I am
looking for ..

trunc(insert_date) >= trunc(sysdate)

....

Boyan Boev