import problem

[jamoji]

I am exporting a table with a query and everything's all right :

exp mercedes/mercedes@prueba tables=provincia query=\"where idprovincia between 5 and 45\" log=jaime2.log file=jaime2.dmp

But when I import it,it doesn't work.Somebody can help me,please?:

imp jaime2/jaime2@prueba touser=jaime2 file=jaime2.dmp log=jaime3.log full=y ignore=y

[jamoji]

...Another thing,please...How can I overwrite the data when I import?.For example I import a table everyday,and I want to overwrite the data everyday...

[oravijay]

Hi,

1. Please post the error message what it gives when u do a import.
2. You cannot. You will have to remove the records, otherwise Oracle just keeps
on appending the no. of rows.

Vijay.

[Mr.Hanky]

Well for starters you have touser specified and no fromuser, you also specified FULL=Y, this is a contradiction to a user level import.

I always truncate tables if I am going to overwrite data prior to import.

As oravijay said please list the error and Oracle versions.

MH