Home » RDBMS Server » Server Utilities » IMP-00041: Warning: object created with compilation warnings
IMP-00041: Warning: object created with compilation warnings [message #461549] |
Fri, 18 June 2010 14:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sus_dreamland
Messages: 2 Registered: June 2010
|
Junior Member |
|
|
For the export and import I am doing teh following steps:
1.Export the tablse space from the test machine where the whole stack is created
exp system/password@orcl file="data/OracleDump/arsystem.dmp" OWNER="ARADMIN";
2.Following steps to import: These steps followed by installer before it imports the tablespace on the destination machine
• CREATE TEMPORARY TABLESPACE ARTMPSPC TEMPFILE '/data/ORACLE/DATABASES/ORCL/artmp' SIZE 250M REUSE AUTOEXTEND ON
• CREATE TABLESPACE ARSYSTEM DATAFILE '/data/ORACLE/DATABASES/ORCL/ARSys' SIZE 7000M REUSE AUTOEXTEND ON
• CREATE USER ARADMIN IDENTIFIED BY AR#Admin# DEFAULT TABLESPACE ARSYSTEM TEMPORARY TABLESPACE ARTMPSPC QUOTA UNLIMITED ON ARSYSTEM
• CREATE ROLE ARADMINROLE NOT IDENTIFIED
• GRANT ARADMINROLE TO ARADMIN
• GRANT ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE TRIGGER, QUERY REWRITE TO ARADMINROLE
3. Import the tablespace on a different box
imp system/password@orcl1 file="/dump/arsystem.dmp" buffer=1024000 fromuser=aradmin touser=aradmin feedback=1000000 log="dump/arsystem.log"
I could see in teh log lot of IMP-00041: Warning: object created with compilation warnings
example:
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "ARADMIN"."BMC_CORE_BMC_IMPACT" ("
""REQUESTID","SUBMITTER","CREATEDATE","ASSIGNEDTO","LASTMODIFIEDBY","MODIFIE"
"DDATE","STATUS","SHORTDESCRIPTION","CMDBROWLEVELSECURITY","INSTANCEID","CMD"
"BWRITESECURITY","NAME","FAILEDAUTOMATICIDENTIFICATION","ACCOUNTID","CLASSID"
"","OPIDWEAKREFERENCE","DATASETID","SOURCE_DATASETID","DESTINATION_DATASETID"
"","MARKASDELETED","RECONCILIATIONIDENTITY","SOURCE_RECONCILIATIONIDENTITY","
""DESTINATION_RECONCILIATIONIDEN","RELLEADINSTANCEID","RELLEADCLASSID","LAST"
"REJOBRUNID","SOURCE_INSTANCEID","SOURCE_CLASSID","DESTINATION_INSTANCEID",""
"DESTINATION_CLASSID","ATTRIBUTEDATASOURCELIST","ZCMDBENGTIMESTAMPSTUB","NOR"
"MALIZATIONSTATUS","IMPACTWEIGHT","IMPACTDIRECTION","HASIMPACT","IMPACTPROPA"
"GATIONMODEL","IMPACTSOURCEID","IMPACTDESTINATIONID") AS "
"SELECT T484.C1,T484.C2,T484.C3,T484.C4,T484.C5,T484.C6,T484.C7,T484.C8,T484"
".C112,T484.C179,T484.C60513,T484.C200000020,T484.C301118000,T484.C301186800"
",T484.C400079600,T484.C400124500,T484.C400127400,T484.C400128800,T484.C4001"
"28900,T484.C400129100,T484.C400129200,T484.C400130900,T484.C400131000,T484."
"C400131200,T484.C400131300,T484.C490001289,T484.C490008000,T484.C490008100,"
"T484.C490009000,T484.C490009100,T484.C530019500,T484.C530032500,T484.C53004"
"1601,T484.C530047901,T484.C530048000,T484.C530048100,T484.C530048200,T484.C"
"530060400,T484.C530060500 FROM T484"
Any suggestion on avoiding this.Do i need to export it with any other options so that i should not be seeing this error.
Please suggest me what should be the best way.
Thanks in Advance.
|
|
|
|
Re: IMP-00041: Warning: object created with compilation warnings [message #461555 is a reply to message #461552] |
Fri, 18 June 2010 14:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sus_dreamland
Messages: 2 Registered: June 2010
|
Junior Member |
|
|
Thanks for the reply Michel.
I am using the export command:
exp system/password@orcl file="data/OracleDump/arsystem.dmp" OWNER="ARADMIN";
should i add any additional option in the command to ensure that i am not missing out any of the dependencies?
Or any options i should add in imp command to ensure the same:
imp system/password@orcl1 file="/dump/arsystem.dmp" buffer=1024000 fromuser=aradmin touser=aradmin feedback=1000000 log="dump/arsystem.log" .
And about the privileges before i start importing i create the user and grant the roles exactly the same what it had earlier on the database from where i exported.
any suggestions?
Thanks
|
|
|
|
Re: IMP-00041: Warning: object created with compilation warnings [message #461592 is a reply to message #461557] |
Sat, 19 June 2010 08:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
babuknb
Messages: 1736 Registered: December 2005 Location: NJ
|
Senior Member |
![babu.knb@gmail.com](/forum/theme/orafaq/images/google.png) ![babudba](/forum/theme/orafaq/images/skype.png)
|
|
Quote:Fix in a way that all dependent objects and privileges are present.
As per Mr Michel check your dependent objects using DBA_DEPENDENCIES
Example:
SQL> create table test1 (a int);
Table created.
SQL> create table test2 (a int);
Table created.
SQL> drop table test2 purge;
Table dropped.
SQL> create table test2 (b int);
Table created.
SQL> create view test_v as select t1.a,t2.b from test1 t1,test2 t2;
View created.
SQL>
SQL> COL OWNER FORMAT A10
SQL> COL NAME FORMAT A10
SQL> L
1* SELECT OWNER,NAME,TYPE,REFERENCED_OWNER,REFERENCED_NAME FROM DBA_DEPENDENCIES WHERE NAME='TEST_V'
SQL> /
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME
---------- ---------- ------------------ ------------------------------ ---------------------------
SYS TEST_V VIEW SYS TEST2
SYS TEST_V VIEW SYS TEST1
SQL>
-Babu
[Updated on: Sun, 20 June 2010 01:04] by Moderator Report message to a moderator
|
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Sep 09 22:20:22 CDT 2024
|