IMP Problem - Synonyms missing
508936Jan 8 2007 — edited Jan 10 2007Sir,
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