943,840 Members | Top Members by Rank

Ad:
  • Oracle Discussion Thread
  • Marked Solved
  • Views: 1457
  • Oracle RSS
Nov 8th, 2008
0

import & export

Expand Post »
Sorry for the simple question...

But please i need help from you guys...

How to import and export the database in oracle..iam have been using oracle 8i in my computer...
im completely new to this environment...
please help on this..

Thanks in advance...
Shanti.
Similar Threads
Reputation Points: 137
Solved Threads: 162
Posting Virtuoso
Shanti C is offline Offline
1,641 posts
since Jul 2008
Nov 8th, 2008
1

Re: import & export

at command prompt type exp help=y you will get the list of parameters for export . repeat the same for import with keyword imp
Featured Poster
Reputation Points: 665
Solved Threads: 427
Posting Genius
debasisdas is offline Offline
6,406 posts
since Feb 2007
Dec 24th, 2008
0

Re: import & export

Hi

At the command line try something like this

c:\> exp system/manager file=myfile.dmp full=y buffer=20000000 log=exp.log

This will take a full export of the database (assuming system password is manager) and put all the data into the file called myfile.dmp. DO NOT try and edit this file as it is a binary file.

You can import this file in full or individual schemas or individual table(s). It's up to you.

Check out this link it has a lot of useful info.
http://wiki.oracle.com/page/Oracle+e...import+?t=anon

Merry Christmas
Alistair
Reputation Points: 10
Solved Threads: 3
Junior Poster in Training
alit2002 is offline Offline
52 posts
since Dec 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

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: How to delete duplicate entries in a table ?
Next Thread in Oracle Forum Timeline: discoverer pus running totals





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


Follow us on Twitter


© 2011 DaniWeb® LLC