Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMP Problem - Synonyms missing

508936Jan 8 2007 — edited Jan 10 2007
Sir,


I am doing an IMPORT. Database - 9.2.0.1.0 OS:Windows 2000

I create all the 9 users

MHUBADMIN, MHUBUSER, MHUBARCHIVE, PPA, PPAUSER, SLIDE, SLIDEUSER, leads, wmc

and assigned default tablespace and

CONNECT,RESOURCE privilege to all users.

Import is working fine. The PROBLEM is, there are some synonyms in SLIDE schema, that is not getting imported.

I generated a import logfile by SHOW option.

"CREATE SYNONYM "BINDING" FOR "SLIDE"."BINDING""
"CREATE SYNONYM "BRANCH" FOR "SLIDE"."BRANCH""
"CREATE SYNONYM "OBJECT" FOR "SLIDE"."OBJECT""
"CREATE SYNONYM "PARENT_BINDING" FOR "SLIDE"."PARENT_BINDING""
"CREATE SYNONYM "PROPERTIES" FOR "SLIDE"."PROPERTIES""
"CREATE SYNONYM "VERSION_CONTENT" FOR "SLIDE"."VERSION_CONTENT""
"CREATE SYNONYM "VERSION" FOR "SLIDE"."VERSION""
"CREATE SYNONYM "URI" FOR "SLIDE"."URI""

These object are available in show.log.

But whilt importing it is missing.

Please help me.

regards
Mathew
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2007
Added on Jan 8 2007
5 comments
595 views