Oracle

import & export

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2008

Posts: 1,071

Reputation: Shanti Chepuru is on a distinguished road

Solved Threads: 98

Shanti Chepuru Shanti Chepuru is offline

Offline

Veteran Poster

import & export

Nov 8th, 2008

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.

Be intelligent, But Don't try to cheat.. Be innocent But Don't get cheated..

•

Join Date: Feb 2007

Posts: 2,080

Reputation: debasisdas will become famous soon enough

Solved Threads: 124

debasisdas debasisdas is offline

Offline

Postaholic

Re: import & export

Nov 8th, 2008

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

Share your Knowledge.

•

Join Date: Dec 2006

Posts: 44

Reputation: alit2002 is an unknown quantity at this point

Solved Threads: 1

alit2002

Offline

Light Poster

Re: import & export

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