Home » RDBMS Server » Server Utilities » import data of one table from dump and import single table based on condition (2 threads merged by b
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 Go to next message
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
Re: import single table based on condition [message #357280 is a reply to message #357278] Tue, 04 November 2008 09:56 Go to previous messageGo to next message
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
Re: import single table based on condition [message #357422 is a reply to message #357280] Wed, 05 November 2008 05:20 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Hello,

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

Babu
Re: import single table based on condition [message #357774 is a reply to message #357280] Thu, 06 November 2008 09:12 Go to previous messageGo to next message
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
import data of one table from dmp [message #357775 is a reply to message #357278] Thu, 06 November 2008 09:15 Go to previous messageGo to next message
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
Re: import data of one table from dmp [message #357786 is a reply to message #357775] Thu, 06 November 2008 09:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: import single table based on condition [message #357806 is a reply to message #357774] Thu, 06 November 2008 12:54 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
No.
Previous Topic: problem different date format loading using sqlldr
Next Topic: import problem
Goto Forum:
  


Current Time: Sat Dec 10 04:47:48 CST 2016

Total time taken to generate the page: 0.04957 seconds