Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Import / Export Problem

Import / Export Problem

From: Susan Dillon <dillon_at_expert.cc.purdue.edu>
Date: 15 Jul 1998 17:21:38 GMT
Message-ID: <6oiof2$ob9@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 Wed Jul 15 1998 - 12:21:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US