Thread: import & export
View Single Post
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

 
0
  #3
Dec 24th, 2008
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
Reply With Quote