OEM Import Wizard Task

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 1 Sep 2000 10:52:16 +0100
Message-Id: <10606.116057@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0011_01C01402.B18298B0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Can you help? I have created an export file on our mainframe and put on a floppy. I am now trying to import it into an Oracle 8i instance on an NT server using OEMs import wizard. I have successfully managed to import the file using the MSDOS version of import so I know it should work OK.

When I try to create a job to do the import, I specify an import task and then click on the parameters tab of the import task. I then have to click on the details butt on and another dialog comes up asking me for the name of the import file. I do not seem to be given the option to specify the parameter file. So I hopefully click on the next button, only to find that this promptly launches an internal job to do the import.

This eventually aborts with 'IMP 00058 Oracle error 12158 encountered' which means 'TNS:could not resolve service name'.

So I have 2 problems.

I am unable to create and save a job to do an import without executing some internal job.
I am unable to specify any parameters to the import job so I'm not surprised it cannot find the database in which to import.

The documentation is no help at all, neither the administrators guide (page 4-24) , which refers you to the online help nor the online help which doesn't mention an import parameter file.

Any help appreciated.

Mark Leith

Cool Tools UK Ltd
+44 1905 330 281
mark_at_cool-tools.co.uk

------=_NextPart_000_0011_01C01402.B18298B0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV>
Can you help? I have created an export file on our =
mainframe and=20
put on a floppy.<SPAN=20 class=3D545163709-01092000> I am now trying to import it into an = Oracle 8i=20
instance on an NT server using = OEMs import=20
wizard. I have successfully = managed to=20
import the file using the MSDOS version of=20
import so I know it =
should work=20
OK.
When I try to create a job to do the import, I specify =
an import=20
task and then click on<SPAN=20 class=3D545163709-01092000> the parameters tab of the import = task. I then=20
have to click on the details =
butt<SPAN=20

class=3D545163709-01092000> on =
and=20

another dialog comes up asking me for the name of the import file. I = do<SPAN=20
class=3D545163709-01092000> not =
seem=20

to be given the option to specify the parameter file. So I = hopefully<SPAN=20
class=3D545163709-01092000> click on=20
the next button, only to find that this promptly launches an =
internal job=20
to do the import.
This eventually aborts with 'IMP 00058 Oracle error =
12158=20
encountered' which means<SPAN=20 class=3D545163709-01092000> 'TNS:could not resolve service name'. =


So I have 2 problems.
1. I am unable to create and save a job to do an =
import without=20
executing some internal = job.
2. I am unable to specify any parameters to the import =
job so=20
I'm not surprised it cannot<SPAN =

class=3D545163709-01092000> find the database in which to import. =


The documentation is no help at all, neither the =
administrators=20
guide (page 4-24) , which refers = you to=20
the online help nor the online = help which=20
doesn't mention an import parameter file.
Any help =

appreciated.</DIV>
<DIV>Mark Leith</DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>=

<DIV>Cool Tools UK =
Ltd</DIV>
<DIV>+44 1905 330 =
281</DIV>
<DIV><A=20

href=3D"mailto:mark_at_cool-tools.co.uk">mark_at_cool-tools.co.uk</A></D= Received on Fri Sep 01 2000 - 04:52:16 CDT