Home -> Usenet -> comp.databases.oracle -> Help with Import ORACLE

Help with Import ORACLE

From: M Bouloussa <mb_at_asterop.com>
Date: 6 Sep 2004 09:45:18 -0700
Message-ID: <ab03d38.0409060845.3976d638_at_posting.google.com> 





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 - 18:45:18 CEST












Original text of this message