Home » RDBMS Server » Server Utilities » To avoid duplicate rows in oracle 8i
To avoid duplicate rows in oracle 8i [message #203203] Tue, 14 November 2006 05:40 Go to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member
Can you suggest how to prevent duplicate rows while in situations where multiple refreshes from a single export file using Oracle 8.1.7?

Do i need to specify Commit=Y, Constraints= N and IGNORE=N while importing data?

Your suggestion would be appreciated.

Thanks in advance.

Report message to a moderator

Re: To avoid duplicate rows in oracle 8i [message #203289 is a reply to message #203203] Tue, 14 November 2006 11:52 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You cannot prevent Import from inserting data.
Oracle will append by default.
If there is a constraint (primary / unique) defined on table and if it violates,then the import will fail.
>>while in situations where multiple refreshes from a single export file
I cannot visualize any such 'situation'.
You are supposed to clean all the data before import.

Report message to a moderator

Previous Topic: Possible to use ...%type in external table field declaration?
Next Topic: Importing full database from the exported backup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 09:01:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.