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  |
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 #473988 is a reply to message #473986] |
Wed, 01 September 2010 18:30  |
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 #474066 is a reply to message #473989] |
Thu, 02 September 2010 09:20 |
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?
|
|
|
|
|
|
Goto Forum:
Current Time: Sat Jan 11 01:57:53 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
