Home » RDBMS Server » Server Utilities » IMP-00041: Warning: object created with compilation warnings
IMP-00041: Warning: object created with compilation warnings [message #473984] Wed, 01 September 2010 17:41 Go to next message
rajesh4851
Messages: 89
Registered: January 2007
Member
dear friends,
I am also getting similar issue.

Every quaterly, we export the data from DEEXTRA and import into INEXTRA user.
This is not working after i made the changes 2 tables and views in DEEXTRA .

I added new columns to 2 tables and associated 2 views. After this change, my import process got failed, with message especially for those views.
"IMP-00041: Warning: object created with compilation warnings"


before i change the tables, import process was working fine.
My doubt is, views were created in INEXTRA before the tables in import functionality.

I had given the grants similary the other objects. I belive no problems with privilages.

Because of table changes the order of the objects in exporting got disturbed? like in the exporting functionality first views created then the table?
or the order of the objects in importing got disturbed? like first views created and then tables?

Pls suggest me.

Re: IMP-00041: Warning: object created with compilation warnings [message #473986 is a reply to message #473984] Wed, 01 September 2010 18:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Here is what we know.

Things (exp & imp) used to work
You made changes (exactly what you decided we did not need to know)
Things, specifically imp, now throws errors.

So I'll summarize & paraphrase the situation.

My car used to work before I made changes.
Now my car won't go.
Tell me how to make my car go again.

1) You don't tell us EXACTLY what changes were made.
2) You don't tell us if same changes were made to both schemas.
3) You don't tell us actual & complete "exp" command line
4) You don't tell us actual & complete "imp" command line
5) You don't tell us Operating System name & version
6) You don't tell us Oracle version from SELECT * FROM V$VERSION

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: IMP-00041: Warning: object created with compilation warnings [message #473988 is a reply to message #473986] Wed, 01 September 2010 18:30 Go to previous messageGo to next message
rajesh4851
Messages: 89
Registered: January 2007
Member
Here are the more details:

I have 2 tables:
CREATE TABLE EMP
       (EMPNO NUMBER(4) NOT NULL,
        ENAME VARCHAR2(10),
        JOB VARCHAR2(9),
        MGR NUMBER(4),
        HIREDATE DATE,
        SAL NUMBER(7, 2),
        COMM NUMBER(7, 2),
        DEPTNO NUMBER(2));

CREATE TABLE DEPT
       (DEPTNO NUMBER(2),
        DNAME VARCHAR2(14),
        LOC VARCHAR2(13) );

CREATE VIEW EMPVIEW 
AS SELECT 
EMPNO , ENAME , JOB ,MGR ,HIREDATE DATE,SAL ,COMM ,DEPTNO 
FROM EMP;

CREATE VIEW DEPTVIEW AS
SELECT DEPTNO , DNAME , LOC FROM DEPT;


I made the changes like the following:

ALTER TABLE EMP ADD 
       (RESIGN_DATE DATE);

ALTER TABLE DEPT
      ADD ( DEPT_MGR NUMBER(2) );

CREATE OR REPLACE VIEW EMPVIEW 
AS SELECT 
EMPNO , ENAME , JOB ,MGR ,HIREDATE DATE,SAL ,COMM ,DEPTNO ,RESIGN_DATE
FROM EMP;

CREATE OR REPLACE VIEW DEPTVIEW AS
SELECT DEPTNO , DNAME , LOC , DEPT_MGR FROM DEPT;


Before the tables/views changes my exp and exp command lines

exp techown/august2010 file=c:\temp\expdump.dmp log=c:\temp\explogging.log 

imp techuser/august file=c:\temp\emp.dmp full=yes


after :

exp techown/august2010 file= c:\temp\expdump.dmp log=c:\temp\explogging.log 

imp techuser/august file=c:\temp\emp.dmp full=yes


Operating System name & version = WINDOWS XP

oracle version : Oracle9i Enterprise Edition Release 9.2.0.1.0
Re: IMP-00041: Warning: object created with compilation warnings [message #473989 is a reply to message #473988] Wed, 01 September 2010 18:48 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Oracle9i Enterprise Edition Release 9Oracle9i Enterprise Edition Release 9.2.0.1.0
I have forgotten more than I remember about V9 & have no DB upon which to test anything.
It would be help if
imp LOG=import.log
so as to see upon which object the error occurs.
It is not clear if exp & imp occur against same or different DB.
I forget behavior when during imp an object already exists and object being imported has different characteristics.
What happens if you run DDL against techuser schema?
Re: IMP-00041: Warning: object created with compilation warnings [message #474066 is a reply to message #473989] Thu, 02 September 2010 09:20 Go to previous messageGo to next message
rajesh4851
Messages: 89
Registered: January 2007
Member
Little changes on the above information i provided:

2 tables and 2 views in DEEXTRA schema before :

CREATE TABLE EMP
       (EMPNO NUMBER(4) NOT NULL,
        ENAME VARCHAR2(10),
        JOB VARCHAR2(9),
        MGR NUMBER(4),
        HIREDATE DATE,
        SAL NUMBER(7, 2),
        COMM NUMBER(7, 2),
        DEPTNO NUMBER(2));

CREATE TABLE DEPT
       (DEPTNO NUMBER(2),
        DNAME VARCHAR2(14),
        LOC VARCHAR2(13) );

CREATE VIEW EMPVIEW 
AS SELECT 
EMPNO , ENAME , JOB ,MGR ,HIREDATE DATE,SAL ,COMM ,DEPTNO 
FROM EMP;

CREATE VIEW DEPTVIEW AS
SELECT DEPTNO , DNAME , LOC FROM DEPT;


I CHANGED like the following:

CREATE TABLE EMP
       (EMPNO NUMBER(4) NOT NULL,
        ENAME VARCHAR2(10),
        JOB VARCHAR2(9),
        MGR NUMBER(4),
        HIREDATE DATE,
        SAL NUMBER(7, 2),
        COMM NUMBER(7, 2),
        DEPTNO NUMBER(2));

CREATE TABLE DEPT
       (DEPTNO NUMBER(2),
        DNAME VARCHAR2(14),
        LOC VARCHAR2(13) );

CREATE VIEW EMPVIEW 
AS SELECT 
EMPNO , ENAME , JOB ,MGR ,HIREDATE DATE,SAL ,COMM ,DEPTNO 
FROM [b]DEEXTRA.[/b]EMP;

CREATE VIEW DEPTVIEW AS
SELECT DEPTNO , DNAME , LOC FROM [b]DEEXTRA.[/b]DEPT;


I added the schema name infront of the table in views. Is this causing error while importing the data from DEEXTRA to INEXTRA?
Re: IMP-00041: Warning: object created with compilation warnings [message #474070 is a reply to message #474066] Thu, 02 September 2010 09:24 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
It would be help if
imp LOG=import.log
so as to see upon which object the error occurs.

Why are you so reluctant to post this simple thing instead of all your stuff that is not asked?

Regards
Michel
Previous Topic: Reading from Oracle Dump
Next Topic: How to read an Oracle DMP file
Goto Forum:
  


Current Time: Thu Mar 28 05:59:34 CDT 2024