Oracle RSS Oracle RSS

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

Quick Reply to Thread
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



2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy enterprise enterprise2.0 enterprisesoftware federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC