0

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.

3
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by alit2002
1

at command prompt type exp help=y you will get the list of parameters for export . repeat the same for import with keyword imp

Votes + Comments
Simple solutions are often hard to come :)
0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.