Home » RDBMS Server » Server Utilities » overwriting database
overwriting database [message #71305] Mon, 14 October 2002 01:30 Go to next message
girolmat
Messages: 1
Registered: October 2002
Junior Member
hello,
i have got a problem to import a file .dmp, because when i import it, it doesnt overwrite changes made between the time i export my database.
Re: overwriting database [message #71310 is a reply to message #71305] Mon, 14 October 2002 06:17 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
???? U don't understand how import works ....

drop tables before import the dump
Re: overwriting database [message #71454 is a reply to message #71305] Mon, 04 November 2002 18:43 Go to previous message
sharan alva
Messages: 57
Registered: November 1999
Member
Hello,
If you do not drop the table or truncate it, import will simply append the records to the table. That is why you see the data that was being inserted during the time you took the export and the import

- Hope it helps
Previous Topic: defrag 7.3.4 tables, please help
Next Topic: Reconstruct database from .dbf, .ctl files
Goto Forum:
  


Current Time: Mon May 13 17:36:14 CDT 2024