Help with Import ORACLE

Hello,

I have a little problem with an oracle import. My problem is :

1. I have a dump (file.dmp) contains a table T1 (just for this example)
2. I have an oracle schema (user=U1, pass=pass1) contains a table T2 with the same structure as T1 but having different tablespace (data,index) and with different pctFree and pctUsed.
3. I would like to import the file file.dmp in this schema

___

the command
imp U1/pass1 file=file.dmp doesn't work because the table is already exist
the command
imp U1/pass1 file=file.dmp ignore=Y doesn't work

Thank you for help

MB Received on Mon Sep 06 2004 - 11:45:18 CDT