OraFAQ Forum: Server Utilities » import the fresh data into existing schema

Home » RDBMS Server » Server Utilities » import the fresh data into existing schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import the fresh data into existing schema [message #72946]

Sun, 21 December 2003 06:10

shahzad-ul-hasan
Messages: 640
Registered: August 2002

Senior Member

dear sir, pls help me, i want to update the fresh data (new dmp file) into the existing schema without dropping the first one....pls help me.......

Report message to a moderator

Re: import the fresh data into existing schema [message #72947 is a reply to message #72946]

Sun, 21 December 2003 07:49

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You no need to drop the table in target.
just truncate the table.
if u dont truncate the data, the import will just append the data ( which will fail, if there is primary key).

Report message to a moderator

Re: import the fresh data into existing schema [message #72948 is a reply to message #72946]

Sun, 21 December 2003 07:52

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

and that is not an update!!
you are just appending data...
so truncate the table and do the import

Report message to a moderator

Previous Topic:	update data without drop the old table..
Next Topic:	sql loader explanation with example

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 19:38:55 CST 2024