| Re: IMP/EXP utility [message #69420] |
Mon, 31 December 2001 21:22  |
AV.NACHIAPPAN
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  |
chandra
Messages: 31
Registered: October 2000
|
Member |
|
|
Hi Mr AVICHI NACHIAPPAN
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
