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

Home -> Community -> Usenet -> c.d.o.server -> Re: OEM Import fails

Re: OEM Import fails

From: <ian.ledzion_at_lgbow.com>
Date: Mon, 15 Apr 2002 09:05:40 +0200
Message-ID: <a9du42$lre$1@rex.ip-plus.net>


As the import is set up throught OEM using the configuration tools there is no script as such. The target for the job is a database, and the tasks are: 1) Run SQL*Plus Script; 2) Import. The parameters for each are as follows:

SQL*Plus script
DROP USER FOO CASCADE;
CREATE USER "FOO" IDENTIFIED BY "BAR"
  DEFAULT TABLESPACE "DATA"
  TEMPORARY TABLESPACE "TEMP"
  PROFILE DEFAULT

  QUOTA UNLIMITED ON "TEMP"
  QUOTA UNLIMITED ON "DATA"
  QUOTA UNLIMITED ON "INDEX"

  ACCOUNT UNLOCK;
GRANT "CONNECT" TO "FOO";
GRANT "FOO_ADMIN" TO "FOO"; -- Application admin role ALTER USER "FOO" DEFAULT ROLE ALL;
EXIT
;

Import

FILE=\\Ora1\apps\oracle\admin\Export\EXPORT_FOO.DMP LOG=\\Ora1\apps\oracle\admin\Export\IMPORT_FOO.LOG FROMUSER=FOO
GRANTS=y
INDEXES=y
ROWS=y
CONSTRAINTS=y

If I run the above tasks as separate jobs everything is fine, but if I run them in the same job I get the error message IMP-00004 on the import task.

"NorwoodThree" <norwoodthree_at_my-deja.com> wrote in message news:ba03e2c.0204120904.1baa2dcd_at_posting.google.com...
> Please post your import statement or script. This probably isnt a bug.
Received on Mon Apr 15 2002 - 02:05:40 CDT

Original text of this message

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