Re: export database

Make you life easier by using parameter file, then just type

    exp(imp) parfile=c:\........\my_exp.txt

-> d: -> cd Oracle\Ora81\Bin
Shouldn't have to cd, should be in your PATH

> 3. In EXPDAT.DMP file: type any dump file name. Ex. Orn5qa76.dmp
> If copy in the same computer:

Newbies reading your post might be confused. dmp files are binary files. can't change (and don't try !).
You mean RENAME it.

> To copy an Oracle database (suppose orn5qa76) from one to another in
> different computer or the same computer:
> 1. Go to Start -> Run -> Command -> d: -> cd Oracle\Ora81\Bin
> 2. type: exp system/manager_at_orn5qa76 and then accept the default by
> simply pressing Enter key.
> 3. In EXPDAT.DMP file: type any dump file name. Ex. Orn5qa76.dmp
> If copy in the same computer:
> 4. create another database naming as ex. Orn5qa77.
> 5. do step 1.
> 6. type: imp system/manager_at_orn5qa76 and then accept the default by
> simply pressing Enter key.
> 7. at a point, we should say yes to import entire export file.
> If copy in the different computers:
> 4. install Oracle server in another computer.
> 5. copy that dump file (orn5qa76.dmp) to the directory of
> d:\Oracle\Ora81\
> Bin\
> 6. create another database naming as ex. Orn5qa77 or orn5qa76 (same
> name).
> 7. do step 1.
> 8. type: imp system/manager_at_orn5qa76 and then accept the default by
> simply pressing Enter key.
> 9. at a point, we should say yes to import entire export file.
>
> Thank you guys.
>
> Luping
>
>
>
>
>
> "Jim Kennedy" <kennedy-family_at_home.com> wrote in message
news:<PFaJ7.35963$XJ4.20515806_at_news1.sttln1.wa.home.com>...
> > If you look in the manual (which is probably your hard drive) under
> > utilities there is a complete description replete with examples. If you
> > have multiple instances running then log in as the proper user to an
> > instance. eg username/password_at_instance1
> > Jim
> > "Roben Zhang" <lzhang_at_opentext.com> wrote in message
> > news:208636ca.0111160746.3b3eb305_at_posting.google.com...
> > > Thanks for your reply. Unfortunately, i don't know how to answer those
> > > questions except username, password. Can you give me more details.
> > > After exp, should i do imp for import? By the way, i have multiple
> > > databases in the same computer. Will the prompt ask which database am
> > > i going to export at a certern point?
> > >
> > > Thanks Luping
> > >
> > > "Jim Kennedy" <kennedy-family_at_home.com> wrote in message
> > news:<ebSI7.32176$XJ4.18318069_at_news1.sttln1.wa.home.com>...
> > > > Use the easy way. Go to a prompt and type exp and answer the
questions.
> > > > Jim
> > > >
> > > >
> > > > "Roben Zhang" <lzhang_at_opentext.com> wrote in message
> > > > news:208636ca.0111150702.1e2fd348_at_posting.google.com...
> > > > > Hi, All
> > > > >
> > > > > I tried to export a database to another in the same computer. But
i
> > > > > got the message saying: "The wizard can only be launched when the
> > > > > application is connected to the Oracle Management Server(OMS).
Launch
> > > > > the application and connect the OMS before trying to launch the
wizard
> > > > > again."
> > > > >
> > > > > I am working on Oracle 8.1.6 in NT Server.
> > > > >
> > > > > My steps are as followings:
> > > > > Start -> Programs -> Oracle - OraHome81 -> Database
Administration ->
> > > > > DBA Studio and select radio 'Launch DBA Studio Standalone'. In
window
> > > > > Oracle DBA Studio, highlight the database i want to export and
select
> > > > > Tools -> Data Management -> Export. Then i will get that message.
> > > > >
> > > > > Is this the right way to do export? How can i get rid of this
message.
> > > > >
> > > > > If i select radio 'Login to the Oracle Management Server' and
login, i
> > > > > will get a message saying: "VTK-1002:The Oracle Management Server
you
> >
> > > > > are trying to connect to is still in the process of
initialization.
> > > > > Please wait for it to start up completely and then try logging in
> > > > > again." I have already started Oracle Management Server.
> > > > >
> > > > > Should i select this radio?
> > > > >
> > > > > Any comments are appreciated.
> > > > >
> > > > > Luping
> > > > > lzhang_at_opentext.com
Received on Fri Nov 23 2001 - 23:20:17 CST