Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OEM Import fails
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"
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