import & export
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.
Shanti C
Posting Virtuoso
1,642 posts since Jul 2008
Reputation Points: 137
Solved Threads: 162
at command prompt type exp help=y you will get the list of parameters for export . repeat the same for import with keyword imp
debasisdas
Posting Genius
6,870 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
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+export+and+import+?t=anon
Merry Christmas
Alistair
alit2002
Junior Poster in Training
52 posts since Dec 2006
Reputation Points: 10
Solved Threads: 3
