OraFAQ Forum: Server Utilities » EXPORT AND IMPORT

Home » RDBMS Server » Server Utilities » EXPORT AND IMPORT (ORACLE 11G R2 X86 win_xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXPORT AND IMPORT [message #499303]

Mon, 14 March 2011 08:27

shuilanseyouyu
Messages: 2
Registered: March 2011
Location: china

Junior Member

i want to transfer my data from one to another;
so i creat another database use the same instance and the same user in two laptop,eg:
1,instance=R20DB table=ENOTB user=ev5adm;
2,instance=R20DB table=ENOTB user=ev5adm;

i use "
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
exp system/Abcd1234@R20DB file=c:\ev5adm.dmp log=c:\ev5adm.log owner=ev5adm "to export,and there is no warnings;

and user"
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
imp system/Abcd1234@R20DB file=c:\ev5adm.dmp log=c:\ev5adm.log fromuser=ev5adm touser=ev5adm" to import,and there is IMP-00041;

how can i resolve this problem?

[mod edit] color removed

[Updated on: Wed, 16 March 2011 08:28] by Moderator

Report message to a moderator

Re: EXPORT AND IMPORT [message #499305 is a reply to message #499303]

Mon, 14 March 2011 08:33

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Please post the entire import log. Retyping a single line from your import command does not help.

Report message to a moderator

Re: EXPORT AND IMPORT [message #499307 is a reply to message #499303]

Mon, 14 March 2011 08:50

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

IMP-00041: Warning: object created with compilation warnings
 *Cause:  The object in the SQL statement following this error was created
          with compilation errors. If this error occurred for a view, it
          is possible that the base table of the view was missing.
 *Action: This is a warning. The object may have to be recompiled before
          being used.

Missing privileges?

Regards
Michel

Report message to a moderator

Re: EXPORT AND IMPORT [message #499444 is a reply to message #499307]

Mon, 14 March 2011 22:31

shuilanseyouyu
Messages: 2
Registered: March 2011
Location: china

Junior Member

OK,there is the log

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V11.02.00 via conventional path
import done in AL32UTF8 character set and UTF8 NCHAR character set
. importing EV5ADM's objects into EV5ADM
. . importing table "ACI" 12214 rows imported
. . importing table "ADMINID" 112 rows imported
. . importing table "ADMINVBUSINESSDOMAINSA" 41 rows imported
. . importing table "ADMINVDATADOMAINSA" 41 rows imported
. . importing table "ADMINVDATASERVERSA" 3 rows imported
. . importing table "ADMINVDOMAINSA" 24 rows imported
. . importing table "ADMINVPROJECTSA" 1 rows imported
. . importing table "ATTRACIAUTHVALUESA" 1770 rows imported
. . importing table "COMMAND" 113 rows imported
. . importing table "COMMANDRELATEDPREDICATSA" 56 rows imported
. . importing table "CONDITION" 43 rows imported
. . importing table "CONDITIONRELATEDPREDICATSA" 24 rows imported
. . importing table "DATAGROUP" 14 rows imported
. . importing table "DOMAINVBUSINESSDOMAINSA" 41 rows imported
. . importing table "ENUMPREDICAT" 61 rows imported
. . importing table "ENUMPREDICATRELATEDVALUEA" 156 rows imported
. . importing table "EVENTS" 153 rows imported
. . importing table "EXTENSIONS" 5606 rows imported
. . importing table "GIMASTER" 94 rows imported
. . importing table "GIVERSION" 94 rows imported
. . importing table "GIVERSIONV506STATUSA" 369 rows imported
. . importing table "MASK" 2 rows imported
. . importing table "OBJECTACI" 2967 rows imported
. . importing table "OBJREF" 16646 rows imported
. . importing table "OBPROPERTY" 16646 rows imported
. . importing table "OPERATION" 215 rows imported
. . importing table "OPERATIONRELATEDCOMMANDSA" 289 rows imported
. . importing table "PREDICAT" 68 rows imported
. . importing table "PRIVILEGE" 300 rows imported
. . importing table "PROCESS" 982 rows imported
. . importing table "PROCESSGROUP" 18 rows imported
. . importing table "PROCESSGROUPPROCESSESA" 1560 rows imported
. . importing table "PROJECTVDATADOMAINSA" 41 rows imported
. . importing table "RDBATTRMAPPING" 14637 rows imported
. . importing table "RDBDE" 9 rows imported
. . importing table "RDBDL" 17 rows imported
. . importing table "RDBENTITYMAPPING" 598 rows imported
. . importing table "RDBIDENTIFIER" 480 rows imported
. . importing table "RDBINHERITANCE" 1450 rows imported
. . importing table "RSCBASE" 237 rows imported
. . importing table "RSCBASEVMASKSA" 1 rows imported
. . importing table "RSCCONTEXT" 50 rows imported
. . importing table "RSCRELATION" 63 rows imported
. . importing table "RSCRELATIONVCOMPONENTSA" 455 rows imported
. . importing table "STATUS" 369 rows imported
. . importing table "STATUSALLOWEDTRANSITIONSA" 540 rows imported
. . importing table "TRANSITION" 540 rows imported
. . importing table "V506BRANCH" 10619 rows imported
. . importing table "V508GENERICCOMP" 33 rows imported
. . importing table "VAULTDOCUMENT" 18396 rows imported
. . importing table "VPMASSEMBLYRELATION" 581 rows imported
. . importing table "VPMDOCFILE" 16332 rows imported
. . importing table "VPMDOCUMENTITERATION" 5663 rows imported
. . importing table "VPMDOCUMENTITERATIONFORMAT" 16332 rows imported
. . importing table "VPMDOCUMENTITERATIONVA0001A" 16332 rows imported
. . importing table "VPMDOCUMENTREVISION" 1304 rows imported
. . importing table "VPMITEMINSTANCE" 652 rows imported
. . importing table "VPMITEMINSTANCECPROPERTIESA" 9 rows imported
. . importing table "VPMITEMINSTANCEVDISCIPLINEA" 2 rows imported
. . importing table "VPMITEMINSTANCEVPARENTPCOA" 13 rows imported
. . importing table "VPMPARTMASTER" 1287 rows imported
. . importing table "VPMPARTVERSION" 1287 rows imported
. . importing table "VPMPARTVERSIONCPROPERTIESA" 1178 rows imported
. . importing table "VPMPRODUCTCLASS" 7 rows imported
. . importing table "VPMPRODUCTROOTCLASS" 14 rows imported
. . importing table "VPMPRODUCTROOTCLASSCPR0001A" 33 rows imported
. . importing table "VPMTECHRELATION" 47 rows imported
. . importing table "VPMTPDOCUMENTFAMILY" 1304 rows imported
. . importing table "VPMTPDOCUMENTMASTER" 1304 rows imported
. . importing table "VPMTPDOCUMENTMASTERVKE0001A" 6 rows imported
. . importing table "VPMTPDOCUMENTVERSIONCP0001A" 9501 rows imported
. . importing table "VPMTPDOCUMENTVERSIONVA0001A" 5663 rows imported
. . importing table "VPMTPFOLDERMASTER" 1 rows imported
. . importing table "VPMTPFOLDERVERSION" 1 rows imported
. . importing table "VPMTPPROPERTY" 14034 rows imported
. . importing table "VPMTPPROPERTYCPROPERTIESA" 13999 rows imported
. . importing table "VPMTPRELATIONCFROMA" 6327 rows imported
. . importing table "VPMTPRELATIONCTOA" 13872 rows imported
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "EV5ADM"."AFLPSOBJECTR" ("OID",""
"TYPE","COBJECTID","CMODIFIED","VVALUE0005","VTYPE","CCREATED","CMANUALLYADD"
"ED","CACTUALLYCHANGED","VOBJECTDESCRIPTION","CCHANGETYPE","C506OBJECTS","CC"
"HANGEACTION","VNAME","COBJECTSI0006","COBJECTSI0007$","COBJECTSI0008#","VSO"
"URCE","V506GRAPH","VUSER","VPRIORITY","VORGANIZATION","VPROJECT0004","VSTAT"
"US","LASTUPDATEDATE","LASTMODIFIERID","LOCKSTATUS","LOCKUSER","LOCKTIMESTAM"
"P","DATADOMAIN","OWNERSITE") AS "
"SELECT ALL OID, TYPE, "COBJECTID","
" "CMODIFIED", "VVALUE0005", "VTYPE", "CCREATED", "CMANUALLYADDED", "CACTUAL"
"LYCHANGED","
" "VOBJECTDESCRIPTION", "CCHANGETYPE", "C506OBJECTS", "CCHANGEACTION","
" "VNAME", "COBJECTSI0006", "COBJECTSI0007$", "COBJECTSI0008#", "VSOURCE","
" "V506GRAPH", "VUSER", "VPRIORITY", "VORGANIZATION", "VPROJECT0004", "VSTAT"
"US","
" LASTUPDATEDATE, LASTMODIFIERID, LOCKSTATUS, LOCKUSER, LOCKTIMESTAMP,"
" DATADOMAIN, OWNERSITE FROM "AFLAFFECTEDOBJECT" UNION ALL SELECT OID,"
" TYPE, "COBJECTID", "CMODIFIED", "VVALUE0005", "VTYPE", "CCREATED", "CMANUA"
"LLYADDED","
" "CACTUALLYCHANGED", "VOBJECTDESCRIPTION", "CCHANGETYPE", "C506OBJECTS","
" "CCHANGEACTION", "VNAME", "COBJECTSI0006", "COBJECTSI0007$", "COBJECTSI000"
"8#","
" "VSOURCE", "V506GRAPH", "VUSER", "VPRIORITY", "VORGANIZATION", "VPROJECT00"
"04","
" "VSTATUS", LASTUPDATEDATE, LASTMODIFIERID, LOCKSTATUS, LOCKUSER, LOCKTIMES"
"TAMP,"
" DATADOMAIN, OWNERSITE FROM "AFLBASEOBJECT""

Report message to a moderator

Re: EXPORT AND IMPORT [message #499445 is a reply to message #499444]

Mon, 14 March 2011 22:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

why does "CREATE FORCE VIEW "EV5ADM"."AFLPSOBJECTR" throw error?

only you can solve this mystery, because we don't have your DB

Report message to a moderator

Re: EXPORT AND IMPORT [message #499467 is a reply to message #499444]

Tue, 15 March 2011 00:11

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

OK,there is the log

What should be interesting is the part with the error you didn't post.

Did you read and try to answer the question I asked:

Quote:

Missing privileges?

Did you try to recompile the views afterwards?
What is the result?

Regards
Michel

Report message to a moderator

Previous Topic:	Unable to Create Control file
Next Topic:	Error: An unhandled win32 exception occured in ctxhx.exe

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 18:45:10 CDT 2024