Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing into a new tablespace with a new user DK58974
Hi,
imp73 fromuser=<user in the dump file> touser=<newuser> file=blabla using sys or system account to do the import.
u should have the import view created in ur new instance...
And it should work
"DK15798" <kwall7904_at_hotmail.com> a écrit dans le message de news:
9acfd9f2.0309111253.52fb2df4_at_posting.google.com...
> I am having trouble importing into a new database. The new database
> has a new user, and tablespace. When I try to import into the new
> database I get the following error.
>
> IMP-00017: following statement failed with ORACLE error 942:
>
> (code to create some trigger goes here)
>
> IMP-00003: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> Import terminated successfully with warnings.
>
> I have tried to import using the same user id as the old database and
> it works just fine (the tablespace is still different). It just won't
> let me import into a new user id.
>
> I have tried:
>
> IMP73 USERID=<newuser> FILE=<file> IGNORE=y GRANTS=n FULL=y
> INDEXFILE=<indexfile> ROWS=n (I tried to run the index file before
> import, didn't work)
>
> IMP73 USERID=<newuser> FROMUSER=<olduser> TOUSER=<newuser> FILE=<file>
> IGNORE=Y
>
> IMP73 <newuser> file=<file> ignore=y grants=n full=y
>
> Any help or suggested reference material would be helpful.
>
> Thanks in advance for the help.
Received on Fri Sep 12 2003 - 09:54:43 CDT