Home » RDBMS Server » Server Utilities » Re: IMP/EXP utility
Re: IMP/EXP utility [message #69420] Mon, 31 December 2001 21:22 Go to next message
Messages: 9
Registered: December 2001
Junior Member
you can use the export utilitity to export the
database from ntsever using export database
option 1.

then go to your p08 machine and use the
utility imp80 and give parameter destroy=y
so that it will destroy any existing files and
will create the new po8 files.

first import with system option and then once
again import with restore option.

system option makes the structures like your po8
database and restore option imports the rows and
datas of the database.

you should keep in mind that the versions used
in nt and p08 are similar versions. if nt has
8 and p0has version 7 then it is a problem.

so match your versions and do the export/import

you can also get help in the exp80 prompt by
typing exp80 help=y

if still you have doubts please mail me

wish you a happy new year thanks

Re: IMP/EXP utility [message #69434 is a reply to message #69420] Sat, 05 January 2002 02:00 Go to previous message
Messages: 31
Registered: October 2000
Thanks for reply
I did the same what u explained.
Here I am giving the problem what I faced
while I am exporting oracle8.0 from NT server(4.0) and Importing to windows95 personnel oracle 8.0 The Varchar2 becoming char and number becoming float(126).
I need exact clarification from you how to rectify this problem.
Thanks & Regards
Chandra, Hyd
Previous Topic: Re: FREE OCP PAPERS
Next Topic: Re: oracle dba papers
Goto Forum:

Current Time: Sat Mar 02 14:49:17 CST 2024