Re: export database

Jim,

Thanks for your reply and sorry for having writen back late because i just came back from my vocation.

The problem is solved! I did the followings. i want to post it here to share with all of you.

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 - 10:54:07 CST