Home » RDBMS Server » Backup & Recovery » import error
import error [message #154986] Wed, 11 January 2006 10:21 Go to next message
ramesh66
Messages: 8
Registered: September 2005
Location: coimbatore
Junior Member
Hello,

I have created new database and imported the database successfully without warnings in 9i

Again , I would like to import for the same database
(i.e latest database file)
ie overwrite existing data's and table structure

"imp username/password file=source log=e:\extract.log"

What is to be given to overwrite existing data's and table structure in the time of import ?

Regards
Ramesh

Report message to a moderator

Re: import error [message #154988 is a reply to message #154986] Wed, 11 January 2006 10:55 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96652/toc.htm
By default , oracle will append the data.
To overwrite, you must first remove the existing data using truncate statement and import only the data
import with ignore=y
But if the structure of the tables are changed, then you may want to import table structure and data. SO first drop the tables in target, export and import.
SEARCH the forum for more examples.

Report message to a moderator

Previous Topic: Exporting Triggers
Next Topic: select * from SYS.V$ARCHIVED_LOG no rows selected
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 01 18:24:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.