Oracle Error 2270 Encountered
Wed, 19 Dec 2001 17:03:24 -0800 Message-ID:
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Problem in http://www.orafaq.com/maillist/oracle-l/2001/12/19/1449.htm Import Want to Advertise Here? Solved Problem in Import Posted on 2000-11-29 Oracle Database 1 Verified Solution 7 Comments 177 Views Last Modified: 2010-03-23 I am getting the following problem, when i run an import file in my WINNT4 based Oracle8i database....This is not the complete log file ....I am https://www.experts-exchange.com/questions/12023699/Problem-in-Import.html just giving the error part. All the columns in the primary keys of the tables mentioned are number fields... can any body provide the solution????? __________________________________________ IMP-00017: following statement failed with ORACLE error 1450: "ALTER TABLE "PARTSREQAQUOTE" ADD PRIMARY KEY ("RAQ_CODE","OWNR_CODE") ENABLE" IMP-00003: ORACLE error 1450 encountered ORA-01450: maximum key length (1578) exceeded . . importing table "PARTSSUBCATEGORY" 15 rows imported IMP-00017: following statement failed with ORACLE error 1450: "CREATE UNIQUE INDEX "XPKPQUOTEDETAIL" ON "PQUOTEDETAIL" ("RAQ_CODE" , "REQU" "ESTOR_CODE" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 131072 NE" "XT 131072 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0 FREELISTS 1 FREELIST G" "ROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING" IMP-00003: ORACLE error 1450 encountered ORA-01450: maximum key length (1578) exceeded IMP-00017: following statement failed with ORACLE error 1450: "ALTER TABLE "PQUOTEDETAIL" ADD PRIMARY KEY ("RAQ_CODE","REQUESTOR_CODE") E" "NABLE" IMP-00003: ORACLE error 1450 encountered ORA-01450: maximum key length (1578) exce
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=13047 Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | Question Most of my databases oracle error are on version 12.1 11.2 11.1 10.2 10.1 or lower Answer and see the results DBA Top 10 1 M. Cadot 35800 2 F. Diaz 34000 3 J. Schnackenberg 16400 4 B. Vroman 15450 5 A. Kavsek 15250 6 P. Wisse 14250 7 T. Boles 13500 8 M. Hidayathullah ... 10900 9 A. Hudspith 9200 10 A. Khan 4100 About Advertise here Download PLATOThe free tool for oracle error 2270 auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47788Total active users2117Act. users last 24h9Act. users last hour1Registered user hits last week756Registered user hits last month6432 Go up Import Order Next thread: ORA-20003 on packaged application Prev thread: Oracle8i OPS Tru64 UNIX --> Oracle9i RAC HP-UX Message Score Author Date Hi I have a schema to be refreshed with productio...... Ravindra Nookala Jun 21, 2005, 16:54 hii This is Mohd Imran Mohiddin, I saw u r Q...... Mohammed Imran Mohiuddin Jun 21, 2005, 17:36 it is still the same. Only way i could reproduce ...... Mahesh Rajendran Jun 21, 2005, 17:52 scott@10g > !imp scott/tiger fromuser=scott tous...... Mahesh Rajendran Jun 21, 2005, 17:53 scott@10g > !imp scott/tiger fromuser=scott touser...... Mahesh Rajendran Jun 21, 2005, 17:54 long story short, you must be using constraints=y...... Mahesh Rajendran Jun 21, 2005, 18:06 Hi Imran It is necessary to disable the constr...... Ravindra Nookala Jun 21, 2005, 18:39 Hi Rajendran You have posted 4 replies. Your ...... Ravindra Nookala Jun 21, 2005, 19:09 It is a single continous session. I have to post ...... Mahesh Rajendran Jun 21, 2005, 19:35 H