Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: OEM Import Wizard Task

Re: OEM Import Wizard Task

From: <Chaim.Katz_at_Completions.Bombardier.com>
Date: Fri, 1 Sep 2000 10:36:58 -0400
Message-Id: <10606.116073@fatcity.com>


--0__=MaRluboWLrTuyKjCwroDYbb7tCkOTXIL0p5MhRyM5Nej57luiKK8AhOM
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

I also don't understand how to use the import wizard, but its easy to use OEM to write a Tcl job script to perform an import. :  exec cmd.exe /c imp parfile=x.par. (the tcl script can chage the working directory or write a par file...) .

The Tcl exp or imp job may show a status of failed. But actually the exp or imp terminated successfully without warnings. I guess it is the return code that imp or exp generates and the version of OEM or IA that I'm using that don't seem to get along.

Hth
Chaim

"Mark Leith" <mark_at_cool-tools.co.uk> on 09/01/2000 06:59:25 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Chaim Katz/Completions/Bombardier)

Subject: OEM Import Wizard Task

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.

  1. I am unable to create and save a job to do an import without executing some internal job.
  2. 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

--0__=MaRluboWLrTuyKjCwroDYbb7tCkOTXIL0p5MhRyM5Nej57luiKK8AhOM
Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWlz by04ODU5LTEiIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlPg0KPE1FVEEgY29udGVudD0iTVNIVE1M IDUuMDAuMjMxNC4xMDAwIiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWT4NCjxESVY+DQo8 UD48Rk9OVCBzaXplPTI+Q2FuIHlvdSBoZWxwPyBJIGhhdmUgY3JlYXRlZCBhbiBleHBvcnQgZmls ZSBvbiBvdXIgbWFpbmZyYW1lIGFuZCANCnB1dCBvbiBhPFNQQU4gY2xhc3M9NTQ1MTYzNzA5LTAx MDkyMDAwPiA8L1NQQU4+ZmxvcHB5LjxTUEFOIA0KY2xhc3M9NTQ1MTYzNzA5LTAxMDkyMDAwPiA8 L1NQQU4+SSBhbSBub3cgdHJ5aW5nIHRvIGltcG9ydCBpdCBpbnRvIGFuIE9yYWNsZSA4aSANCmlu c3RhbmNlIG9uIGFuIE5UIHNlcnZlcjxTUEFOIGNsYXNzPTU0NTE2MzcwOS0wMTA5MjAwMD4gPC9T UEFOPnVzaW5nIE9FTXMgaW1wb3J0IA0Kd2l6YXJkLjxTUEFOIGNsYXNzPTU0NTE2MzcwOS0wMTA5 MjAwMD4gPC9TUEFOPkkgaGF2ZSBzdWNjZXNzZnVsbHkgbWFuYWdlZCB0byANCmltcG9ydCB0aGUg ZmlsZSB1c2luZyB0aGUgTVNET1MgdmVyc2lvbiBvZjxTUEFOIGNsYXNzPTU0NTE2MzcwOS0wMTA5 MjAwMD4gDQo8L1NQQU4+aW1wb3J0PFNQQU4gY2xhc3M9NTQ1MTYzNzA5LTAxMDkyMDAwPiA8L1NQ QU4+c28gSSBrbm93IGl0IHNob3VsZCB3b3JrIA0KT0suPC9GT05UPjwvUD4NCjxQPjxGT05UIHNp emU9Mj5XaGVuIEkgdHJ5IHRvIGNyZWF0ZSBhIGpvYiB0byBkbyB0aGUgaW1wb3J0LCBJIHNwZWNp ZnkgYW4gaW1wb3J0IA0KdGFzayBhbmQ8U1BBTiBjbGFzcz01NDUxNjM3MDktMDEwOTIwMDA+IDwv U1BBTj50aGVuIGNsaWNrIG9uPFNQQU4gDQpjbGFzcz01NDUxNjM3MDktMDEwOTIwMDA+IDwvU1BB Tj50aGUgcGFyYW1ldGVycyB0YWIgb2YgdGhlIGltcG9ydCB0YXNrLiBJIHRoZW4gDQpoYXZlIHRv IGNsaWNrIG9uIHRoZSBkZXRhaWxzPFNQQU4gY2xhc3M9NTQ1MTYzNzA5LTAxMDkyMDAwPiA8L1NQ QU4+YnV0dDxTUEFOIA0KY2xhc3M9NTQ1MTYzNzA5LTAxMDkyMDAwPiA8L1NQQU4+b248U1BBTiBj bGFzcz01NDUxNjM3MDktMDEwOTIwMDA+IDwvU1BBTj5hbmQgDQphbm90aGVyIGRpYWxvZyBjb21l cyB1cCBhc2tpbmcgbWUgZm9yIHRoZSBuYW1lIG9mIHRoZSBpbXBvcnQgZmlsZS4gSSBkbzxTUEFO IA0KY2xhc3M9NTQ1MTYzNzA5LTAxMDkyMDAwPiA8L1NQQU4+bm90PFNQQU4gY2xhc3M9NTQ1MTYz NzA5LTAxMDkyMDAwPiA8L1NQQU4+c2VlbSANCnRvIGJlIGdpdmVuIHRoZSBvcHRpb24gdG8gc3Bl Y2lmeSB0aGUgcGFyYW1ldGVyIGZpbGUuIFNvIEkgaG9wZWZ1bGx5PFNQQU4gDQpjbGFzcz01NDUx NjM3MDktMDEwOTIwMDA+IDwvU1BBTj5jbGljayBvbjxTUEFOIGNsYXNzPTU0NTE2MzcwOS0wMTA5 MjAwMD4gDQo8L1NQQU4+dGhlIG5leHQgYnV0dG9uLCBvbmx5IHRvIGZpbmQgdGhhdCB0aGlzIHBy b21wdGx5IGxhdW5jaGVzIGFuIGludGVybmFsIGpvYiANCnRvPFNQQU4gY2xhc3M9NTQ1MTYzNzA5 LTAxMDkyMDAwPiA8L1NQQU4+ZG8gdGhlIGltcG9ydC48L0ZPTlQ+PC9QPg0KPFA+PEZPTlQgc2l6 ZT0yPlRoaXMgZXZlbnR1YWxseSBhYm9ydHMgd2l0aCAnSU1QIDAwMDU4IE9yYWNsZSBlcnJvciAx MjE1OCANCmVuY291bnRlcmVkJyB3aGljaDxTUEFOIGNsYXNzPTU0NTE2MzcwOS0wMTA5MjAwMD4g PC9TUEFOPm1lYW5zPFNQQU4gDQpjbGFzcz01NDUxNjM3MDktMDEwOTIwMDA+IDwvU1BBTj4nVE5T OmNvdWxkIG5vdCByZXNvbHZlIHNlcnZpY2UgbmFtZScuIA0KPC9GT05UPjwvUD4NCjxQPjxGT05U IHNpemU9Mj5TbyBJIGhhdmUgMiBwcm9ibGVtcy48L0ZPTlQ+PC9QPg0KPFA+PEZPTlQgc2l6ZT0y PjEuIEkgYW0gdW5hYmxlIHRvIGNyZWF0ZSBhbmQgc2F2ZSBhIGpvYiB0byBkbyBhbiBpbXBvcnQg d2l0aG91dCANCmV4ZWN1dGluZzxTUEFOIGNsYXNzPTU0NTE2MzcwOS0wMTA5MjAwMD4gPC9TUEFO PnNvbWUgaW50ZXJuYWwgam9iLjwvRk9OVD48L1A+DQo8UD48Rk9OVCBzaXplPTI+Mi4gSSBhbSB1 bmFibGUgdG8gc3BlY2lmeSBhbnkgcGFyYW1ldGVycyB0byB0aGUgaW1wb3J0IGpvYiBzbyANCkkn bSBub3Q8U1BBTiBjbGFzcz01NDUxNjM3MDktMDEwOTIwMDA+IDwvU1BBTj5zdXJwcmlzZWQgaXQg Y2Fubm90PFNQQU4gDQpjbGFzcz01NDUxNjM3MDktMDEwOTIwMDA+IDwvU1BBTj5maW5kIHRoZSBk YXRhYmFzZSBpbiB3aGljaCB0byBpbXBvcnQuIA0KPC9GT05UPjwvUD4NCjxQPjxGT05UIHNpemU9 Mj5UaGUgZG9jdW1lbnRhdGlvbiBpcyBubyBoZWxwIGF0IGFsbCwgbmVpdGhlciB0aGUgYWRtaW5p c3RyYXRvcnMgDQpndWlkZSAocGFnZTxTUEFOIGNsYXNzPTU0NTE2MzcwOS0wMTA5MjAwMD4gPC9T UEFOPjQtMjQpICwgd2hpY2ggcmVmZXJzIHlvdSB0byANCnRoZSBvbmxpbmU8U1BBTiBjbGFzcz01 NDUxNjM3MDktMDEwOTIwMDA+IDwvU1BBTj5oZWxwIG5vciB0aGUgb25saW5lIGhlbHAgd2hpY2gg DQpkb2Vzbid0IG1lbnRpb24gYW4gaW1wb3J0IHBhcmFtZXRlciBmaWxlLjwvRk9OVD48L1A+DQo8 UD48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj48U1BBTiBjbGFzcz01NDUxNjM3MDktMDEwOTIwMDA+ QW55IGhlbHAgDQphcHByZWNpYXRlZC48L1NQQU4+PC9GT05UPjwvUD48L0RJVj4NCjxESVY+PEZP TlQgY29sb3I9IzAwODBmZiBzaXplPTI+PEVNPk1hcmsgTGVpdGg8L0VNPjwvRk9OVD48L0RJVj4N CjxESVY+PEZPTlQgY29sb3I9I2ZmMDAwMCBmYWNlPUFyaWFsIHNpemU9Mj49PT09PT09PT09PT09 PT09PTwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwODBmZiBzaXplPTI+PFNUUk9O Rz5Db29sIFRvb2xzIFVLIEx0ZDwvU1RST05HPjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgY29s b3I9IzAwODBmZiBmYWNlPUFyaWFsIHNpemU9Mj4rNDQgMTkwNSAzMzAgMjgxPC9GT05UPjwvRElW Pg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj48QSANCmhyZWY9Im1haWx0bzptYXJrQGNv b2wtdG9vbHMuY28udWsiPm1hcmtAY29vbC10b29scy5jby51azwvQT48L0ZPTlQ+PC9ESVY+DQo8 Received on Fri Sep 01 2000 - 09:36:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US