OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Import

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

Import [message #59770]

Sun, 21 December 2003 23:19

Dik
Messages: 27
Registered: June 2002

Junior Member

Hi,

I would like to do the import from exp.dmp file in table with records. How can I truncate existent table if there is primary key, unique key.

Thanks

Report message to a moderator

Re: Import [message #59776 is a reply to message #59770]

Mon, 22 December 2003 02:06

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

Senior Member
Account Moderator

u have to do it manually before doing import!.
import utility has no functionality to truncate the data.

Report message to a moderator

Re: Import [message #59779 is a reply to message #59776]

Mon, 22 December 2003 03:42

Dik
Messages: 27
Registered: June 2002

Junior Member

Hi,

How, if I get a message Integity constraint violated, child .... when I use 'delete from xxx.

Thanks

Report message to a moderator

Re: Import [message #59780 is a reply to message #59779]

Mon, 22 December 2003 03:56

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

Senior Member
Account Moderator

which indicates that the table is having the child 
records in anotther table..

Report message to a moderator

Previous Topic:	Installing Oracle 9i
Next Topic:	Moving Index Organized Table in 8.0.5

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:35:35 CDT 2024