OraFAQ Forum: Server Utilities » import data of one table from dump and import single table based on condition (2 threads merged by b

Home » RDBMS Server » Server Utilities » import data of one table from dump and import single table based on condition (2 threads merged by b

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

import data of one table from dump and import single table based on condition (2 threads merged by b [message #357278]

Tue, 04 November 2008 09:53

shrad2001
Messages: 20
Registered: September 2008
Location: faridabad

Junior Member

I want to import one table having data of particular date.How do i do this

can any one help me on this problem

thanks
smily

Report message to a moderator

Re: import single table based on condition [message #357280 is a reply to message #357278]

Tue, 04 November 2008 09:56

S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom

Senior Member

Check this link.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2328

Regards

Raj

Report message to a moderator

Re: import single table based on condition [message #357422 is a reply to message #357280]

Wed, 05 November 2008 05:20

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello,

1/ Try to export using QUERY parameter
2/ Then try to import..

Babu

Report message to a moderator

Re: import single table based on condition [message #357774 is a reply to message #357280]

Thu, 06 November 2008 09:12

shrad2001
Messages: 20
Registered: September 2008
Location: faridabad

Junior Member

thanks for rpl

but i have a dmp and i want to import one table from this dmp based on condition
i means i want to import data of a table for a particular date

can i do this without exporting

thanks
smily

Report message to a moderator

import data of one table from dmp [message #357775 is a reply to message #357278]

Thu, 06 November 2008 09:15

shrad2001
Messages: 20
Registered: September 2008
Location: faridabad

Junior Member

hiii
i want to know how to import data of one table based on condition
i means to import data of table for particular date

thanks
smily

Report message to a moderator

Re: import data of one table from dmp [message #357786 is a reply to message #357775]

Thu, 06 November 2008 09:53

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

Senior Member
Account Moderator

Don't rate your own topic before there is any answer.
Don't multipost your questions.
Post in the appropriate forum.
See answers in the other topic:
http://www.orafaq.com/forum/m/357774/102589/#msg_357774

This one is closed.

Regards
Michel

Report message to a moderator

Re: import single table based on condition [message #357806 is a reply to message #357774]

Thu, 06 November 2008 12:54

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

No.

Report message to a moderator

Previous Topic:	problem different date format loading using sqlldr
Next Topic:	import problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 10:08:02 CST 2024