- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: IMP-00041 and IMP-00017
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2003 02:00 AM
тАО12-09-2003 02:00 AM
IMP-00017: following statement failed with ORACLE error 2437:
"ALTER TABLE "QR_MAP_ATTACH_ALIAS" ADD CONSTRAINT "PK_MAP_ATTACH_ALIAS" PRI"
"MARY KEY ("ATTACH_NAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STO"
"RAGE (INITIAL 512000 NEXT 102400 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCR"
"EASE 0 FREELISTS 1 ) TABLESPACE "USR""
IMP-00003: ORACLE error 2437 encountered
ORA-02437: cannot enable (QARUN.PK_MAP_ATTACH_ALIAS) - primary key violated
and
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "SYSTEM"."TEMPRPT_BYTES" ("TABLE"
"SPACE_NAME","BYTES") AS "
"select tablespace_name,sum(bytes) bytes"
"from dba_data_files"
"group by tablespace_name"
how to make for to resolve it?.
thank you for your assistance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2003 02:34 AM
тАО12-09-2003 02:34 AM
Re: IMP-00041 and IMP-00017
for ORA-02437 maybe there are duplicate values or null values;
so check the table, remove the duplicates and enabling the primary key.
For IMP-00041 during creation of a view owned
by SYSTEM on a view called "dba_data_files"
owned by SYS.
Check if exist a public synonym owned by
SYS called "dba_data_files" and try to
re-create your view.
HTH
regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2003 02:39 AM
тАО12-09-2003 02:39 AM
Re: IMP-00041 and IMP-00017
Solution : your target database should be created with the same CHARACTER SET
cf. Metalink note 107597.1
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2003 08:27 AM
тАО12-09-2003 08:27 AM
Re: IMP-00041 and IMP-00017
select attach_name,count(*) from qr_map_attach_alias group by attach_name having count(*) > 1;
The following will also work as well (I like this one, it is from metalink):
select attach_name from qr_map_attach_alias
where rowid in
(select rowid from qr_map_attach_alias
minus
select max(rowid) from qr_map_attach_alias
group by attach_name)
As for the IMP-00041, this is a normal import error. Views are created sequentially, however because they may call other views inside, if the calling view does not exist, you will get this error. Views are recompiled when used if they are invalid, so when you try to access this view, it will most likely work normally. I wouldn't worry about these, but you will want to check them when you are done by either selecting against them or recompiling them.
ie:
select count(*) from system.temprpt_bytes where rownum = 1;
or
alter view system.temprpt_bytes compile;
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2003 06:06 PM
тАО12-09-2003 06:06 PM
Solutionto add to the above great replies,
(1)
if you now want to delete the duplicate records, use:
delete from QR_MAP_ATTACH_ALIAS a
where rowid <> ( select max(rowid)
from QR_MAP_ATTACH_ALIAS b
where b.ATTACH_NAME = a.ATTACH_NAME)
(2)
As Brian said above, the problem with the view can be resolved automatically. Do a "select * from system.TEMPRPT_BYTES where rownum <2" to see if the view is OK.
regards
yogeeraj