Home » RDBMS Server » Server Administration » I want my IMP to overwrite the existing tables data
I want my IMP to overwrite the existing tables data [message #62478] Fri, 23 July 2004 06:35 Go to next message
sidd
Messages: 130
Registered: May 2003
Senior Member
can anyone send me the imp parfile that overwrites the existing tables table i am using oracle 8174

Report message to a moderator

Re: I want my IMP to overwrite the existing tables data [message #62483 is a reply to message #62478] Fri, 23 July 2004 10:16 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Import will not overwrite existing data.
you need to truncate the table data.
if the table/object is already present,
import will fail ( specify ingore=y to ask imp NOT TO whine when the object is already found).

Report message to a moderator

Previous Topic: how can i know tablespace is fragmented.
Next Topic: Questions regarding recover database until time .
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 04:35:13 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.