OraFAQ Forum: Server Utilities » Can we Add table data via Import Command using oracle database 8.1.5

Home » RDBMS Server » Server Utilities » Can we Add table data via Import Command using oracle database 8.1.5

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

Can we Add table data via Import Command using oracle database 8.1.5 [message #262209]

Sat, 25 August 2007 02:06

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

Can we Add table data via Import Command using oracle database 8.1.5 for example

Employee table has 10 rows i will delete 4 rows from the table before delete or update i make backup of 10 rows now i want to import from backup file but want only those rows added that i delete

Thanks
Faheem

Report message to a moderator

Re: Can we Add table data via Import Command using oracle database 8.1.5 [message #262211 is a reply to message #262209]

Sat, 25 August 2007 02:13

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

imp tries to import the whole table there is no way to tell him which rows to import.
If you have a primary key (and you should) then duplicate rows will be rejected and so you will only import deleted rows.

Regards
Michel

Report message to a moderator

Re: Can we Add table data via Import Command using oracle database 8.1.5 [message #262280 is a reply to message #262209]

Sat, 25 August 2007 21:49

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You have to use

full=y ignore=y

with imp.

And if the table don't have a primary key you can make a primary key with all the columns. Now perform import. Later then drop the primary key.

Report message to a moderator

Re: Can we Add table data via Import Command using oracle database 8.1.5 [message #262366 is a reply to message #262209]

Sun, 26 August 2007 10:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>You have to use: full=y
OP, use at your own risk.
If exp full=y or owner=newbie, the above parameter could change more than just 1 table.

[Updated on: Sun, 26 August 2007 10:09] by Moderator

Report message to a moderator

Previous Topic:	Problems with import on Oracle 8i
Next Topic:	uploading text_file to oracle database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 10:08:30 CST 2024