Import & Export table

Reply

Join Date: Nov 2008
Posts: 1
Reputation: Sonali Mane is an unknown quantity at this point 
Solved Threads: 0
Sonali Mane Sonali Mane is offline Offline
Newbie Poster

Import & Export table

 
0
  #1
Nov 14th, 2008
How to Import & Export tables in Oracle.
Reply With Quote Quick reply to this message  
Join Date: Feb 2007
Posts: 2,076
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 124
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Postaholic

Re: Import & Export table

 
0
  #2
Nov 15th, 2008
if you are using oracle 9i then use EXP to export and IMP to import.
you can use EXPDP/IMPDM for the same in 10g onwards.
Share your Knowledge.
Reply With Quote Quick reply to this message  
Join Date: Dec 2006
Posts: 44
Reputation: alit2002 is an unknown quantity at this point 
Solved Threads: 1
alit2002 alit2002 is offline Offline
Light Poster

Re: Import & Export table

 
0
  #3
Dec 24th, 2008
To access the help utility type the following at the command line

C:\> exp hep=y
or
C:\> imp help=y

All the commands you need are there.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the Oracle Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC