![]() This error means you have to enable partitioning in the Oracle Database engine in order to use this feature, and if you didn't so at installation time you can enable it with this commands: ORA-00439: feature not enabled: Partitioning "ESPACE "MYTABLESPACE" LOGGING NOCOMPRESS )" "RAGE(INITIAL 655360 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABL" "S LESS THAN ('20040301') PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STO" ") TABLESPACE "MYTABLESPACE" LOGGING NOCOMPRESS, PARTITION "TWO" VALUE" "55 STORAGE(INITIAL 655360 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT" " VALUES LESS THAN ('20050301') PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2" "PACE" LOGGING PARTITION BY RANGE ("LOGDATE" ) (PARTITION "ONE"" "ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE "MYTABLES" ![]() "CREATE TABLE "BADTABLE" ("LOGDATE" CHAR(8), "SOMEINFO" CHAR(6) IMP-00017: following statement failed with ORACLE error 439: Import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character setĮxport client uses US7ASCII character set (possible charset conversion) ![]() Let's say that you exported some data with exp of some database with no errors or warnings, and when you're importing it in other database you get an ORA-00439 error:Ĭonnected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit ProductionĮxport file created by EXPORT:V10.02.01 via direct path ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |