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.



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: 10672
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.
Previous Topic: Possible to use ...%type in external table field declaration?
Next Topic: Importing full database from the exported backup
Goto Forum:
  


Current Time: Sun Dec 11 08:02:28 CST 2016

Total time taken to generate the page: 0.08427 seconds