Re: Import / Export Problem

That error is a warning and indicates that the view is referencing some invalid objects in the database. This is not as bad as it sounds. After the import, look for any invalid objects and try to recompile them:

select object_name, object_type, from user_objects where status <> 'VALID';

alter <object_type> <object_name> compile;

example: alter procedure foo compile;

Another thing you can try is to import a second time using the ROWS=N option. The second pass will re-import all your views, grants and stuff without doubling up the rows in your tables. There's a good chance that the second import will go through fine.

HTH Susan Dillon wrote:

> 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 Wed Jul 15 1998 - 22:56:32 CDT