943,632 Members | Top Members by Rank

Web Development > Databases > Oracle > Import & Export table
Ad:
  • Oracle Discussion Thread
  • Unsolved
  • Views: 4297
  • Oracle RSS
Permalink
Nov 14th, 2008
0

Import & Export table

Expand Post »
How to Import & Export tables in Oracle.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Sonali Mane is offline Offline
1 posts
since Nov 2008
Permalink
Nov 15th, 2008
0

Re: Import & Export table

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.
Featured Poster
Reputation Points: 665
Solved Threads: 427
Posting Genius
debasisdas is offline Offline
6,406 posts
since Feb 2007
Permalink
Dec 24th, 2008
0

Re: Import & Export table

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.
Reputation Points: 10
Solved Threads: 3
Junior Poster in Training
alit2002 is offline Offline
52 posts
since Dec 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Oracle Forum Timeline: to get the role of the user
Next Thread in Oracle Forum Timeline: How to delete duplicate entries in a table ?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC