Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems with import

Status
Not open for further replies.
michaelvv

michaelvv

MIS
Jan 17, 2003
70
US
I have a dump of the production database, which I want to import into a test database on a different server. How do I tell import to replace everything? I am getting 'duplicate key' errors. Oracle 9 and AIX 5.3 on both servers.
 
Sort by date Sort by votes
Have you tried using the ignore option or possibly with constraints set to N
 
Upvote 0 Downvote
Thanks for the reply, I had already figured it out. It had been so long since doing an import, I had forgotten to drop the user's existing object s first...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
869
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
1K
SkipVought
S
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
1K
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Change format name with comma 1
Replies
3
Views
310
TheLazyPig
TheLazyPig
gooseriver
  • Locked
  • Question
UPDATE statement - with two tables
Replies
1
Views
229
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top