OraFAQ Forum: Server Utilities » Problem with import full fromuser touser

Home » RDBMS Server » Server Utilities » Problem with import full fromuser touser

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with import full fromuser touser [message #73680]

Thu, 17 June 2004 06:38

Edouard
Messages: 7
Registered: June 2004

Junior Member

I m triing to import full schema into an other schema with

imp username1/password fromuser=username1 touser=username2 file=filename.dmp

all the username1 objects are created in username2 except the snapshots log defined in username1.

i have the following error:

IMP-00015: following statement failed because the object already exists:
�"CREATE SNAPSHOT LOG ON "username1"."tablename" WITH ROWID ...�

IMP try to create the snapshot log object in username1 and not in username2.

Thanks for�your help and sorry for my bad english.�

Edouard

Report message to a moderator

Re: Problem with import full fromuser touser [message #73681 is a reply to message #73680]

Thu, 17 June 2004 07:15

Edouard
Messages: 7
Registered: June 2004

Junior Member

i find that in my dump file the snapshot are declare with " for the schema:

CREATE SNAPSHOT LOG ON "USERNAME1"."TableName" WITH ROWID EXCLUDING NEW...

so if i change the dump like

CREATE SNAPSHOT LOG ON "TableName" WITH ROWID EXCLUDING NEW...

it will work...

So is it a exp bug ? and is there a patch for this.

Thanks a lot

Edouard

Report message to a moderator

Re: Problem with import full fromuser touser [message #73683 is a reply to message #73681]

Thu, 17 June 2004 08:07

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

its not a bug.
seems the object already exists in the targetSchema.
so drop the object and do the import
or
ingore the object and do the import
imp user/pass fromuser=a touser=b file=somefile ignore=y

Report message to a moderator

Re: Problem with import full fromuser touser [message #73684 is a reply to message #73683]

Thu, 17 June 2004 08:20

Edouard
Messages: 7
Registered: June 2004

Junior Member

thank for your response but,

the object don't exist in the target schema (empty schema) but exist in the source schema (schema use to create the dump file).
i thing he try to create the object in the source schema -> IMP-00015 error.
so if i modify the dump file with remove the schema information in the objects which fails, it will work very well... ?????

Report message to a moderator

Re: Problem with import full fromuser touser [message #73685 is a reply to message #73684]

Thu, 17 June 2004 08:53

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I believe yOU can ignore the error.
snapshot/snapshot logs are NOT affected by import with FROMUSER TOUSER.
You need to create the logs manually.
Editing the dmp is not a recomended option.
just generate the ddl for snapshots
do the import with ignore=y
recreate the snapshots

Report message to a moderator

Previous Topic:	SQLLDR: path of the file!
Next Topic:	Damage file during load

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 11:09:44 CDT 2024