Re: Import / Export Problem

There are two likely causes. The views may be referring to objects that are owned by a third owner (i.e. "C"). When you import into "B", then this account does not have privileges on the objects owned by "C".

A similar problem can occur if the views that are owned by A have the owner specified in the FROM clause (i.e. SELECT * FROM A.TABLE) . The import will create a view for B, but B does not have privileges to select from A.TABLE.

Susan Dillon wrote in message <6oiof2$ob9_at_mozo.cc.purdue.edu>...
>I seem to be having an import/export problem that I ccould use some advice
on. I issue the following export command:
>
>"exp sys/passwd FILE=dumpfile.dmp FULL=Y CONSISTENT=Y" and everything works
great.
>
>
>When I issue an import command from user A to user A as follows I have no
problem.
>
>"imp sys/passwd FILE=dumpfile.dmp fromuser=A touser=A"
>
>
>However, when I issue an import command from user A to user B I run into a
problem!
>
>"imp sys/passwd FILE=dumpfile.dmp fromuser=A touser=B"
>
>I do not know a whole lot of sql or Oracle for that matter, however I am
looking for for way to get this data imported to
>user b without these create force view errors (IMP-00041). Oracle tech
support suggested that I use the show=y log=y
>option on import and then make an sql script with the "create force view
portion". There is not an easy way to do this
>since the show=y and log=y put quotes and break up the sql syntax. Does
any one know what I am talking about? And does
>anyone have any ideas for me to try? I am desperate. Please resond to
this post or email me at
>kevin.p.dillon_at_cstar.ac.com.
>
>Thanks in Advance!
>
>Here is a sample of my import error:
>...
>. . importing table "DM_STAGED_S" 0 rows imported
>. . importing table "DM_STORE_R" 1 rows imported
>. . importing table "DM_STORE_S" 1 rows imported
>. . importing table "DM_SYSOBJECT_R" 2999 rows imported
>. . importing table "DM_SYSOBJECT_S" 1719 rows imported
>. . importing table "DM_TYPE_R" 2608 rows imported
>. . importing table "DM_TYPE_S" 71 rows imported
>. . importing table "DM_USER_S" 15 rows imported
>. . importing table "DOCUMENT_TEMPLATE_DEF_S" 359 rows imported
>IMP-00041: Warning: object created with compilation warnings
> "CREATE FORCE VIEW "DORAL_CONTENT"."DM_DUMP_RECORD_SP"
("R"
>

"_OBJECT_ID_I","R_OBJECT_ID","FILE_NAME","R_START_TIME","R_END_TIME","R_ROOT "
>

"_COUNT","R_CURRENT_ROOT_COUNT","R_CURRENT_OBJECT_COUNT","R_CURRENT_POS","IN "
> "CLUDE_CONTENT","DUMP_OPERATION","I_VSTAMP") AS "
> "SELECT

HX_.r_object_id_i,HX_.r_object_id,HX_.file_name,HX_.r_start_time,HX_"
>

".r_end_time,HX_.r_root_count,HX_.r_current_root_count,HX_.r_current_object_ "
>

"count,HX_.r_current_pos,HX_.include_content,HX_.dump_operation,HX_.i_vstamp "
> " FROM colonial_content.dm_dump_record_s HX_ WHERE 1=1 "
>...
Received on Thu Jul 16 1998 - 13:13:57 CDT