OA主题的文章列表，还有OA的技术要点_第2页

Oracle SqlLoader使用

最近在用sqlloader导入数据，500多M，开始要用40分钟，后来做到了20min，再后来只用不到2分钟。所用时间的不断减少，得益于很多网友的总结。数据文件为csv格式，默认打开软件为：excel，通过excel打开的csv文件日期和数字格式可能会发生变化，在写controlfile时要注意了，看原始格式请用文本编...

开发笔记 ·2023-08-10

ORA-30091: secondary translation table not loaded

文档解释ORA-30091:secondarytranslationtablenotloadedCause:ThesecondarytranslationtableforDSTpatchingonTSTZdatawasnotloaded.Action:Loadthesecondarytranslationtable.错...

IT技术学习 ·2023-07-28

ORA-24052: cannot propagate object type payloads with LOB attributes to an 8.0 release

文档解释ORA-24052:cannotpropagateobjecttypepayloadswithLOBattributestoan8.0releaseCause:TherecipientofamessagewithLOBattributeswasusinganOracle8.0release.Propagatio...

IT技术学习 ·2023-07-28

ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

文档解释ORA-19602:cannotbackuporcopyactivefileinNOARCHIVELOGmodeCause:Youtriedtocopyorbackupafilethatwasnotclosedcleanly,andthedatabasewasinNOARCHIVELOGmode.Thisisn...

IT技术学习 ·2023-07-28

ORA-26016: Virtual column string in table string.string cannot be loaded by direct path

文档解释ORA-26016:Virtualcolumnstringintablestring.stringcannotbeloadedbydirectpathCause:Youattemptedtoloadanvirtualcolumnusingthedirectpath.Action:Virtualcolumnsca...

IT技术学习 ·2023-07-28

ORA-53111: The repository data model is not loaded.

文档解释ORA-53111:Therepositorydatamodelisnotloaded.Cause:Theoperationfailedbecausetheord_dicom.setDataModelprocedurewasnotcalledtoloadtherepositorydatamodel.Action...

IT技术学习 ·2023-07-28

ORA-39778: the parallel load option is not allowed when loading lob columns

文档解释ORA-39778:theparallelloadoptionisnotallowedwhenloadinglobcolumnsCause:AnattemptwasmadetoloadlobcolumnsusingtheattributeOCI_ATTR_DIRPATH_PARALLEL.Thiserrorwi...

IT技术学习 ·2023-07-28

ORA-39792: Attribute “string” is not valid for subtypes(s) loaded into column string.

文档解释ORA-39792:Attribute“string”isnotvalidforsubtypes(s)loadedintocolumnstring.Cause:Attributespecifiedwasnotincludedinanysubtypesspecifiedforthecolu...

IT技术学习 ·2023-07-28

ORA-15563: workload replay client cannot spawn new threads

文档解释ORA-15563:workloadreplayclientcannotspawnnewthreadsCause:TheWorkloadReplayClientdoesnothaveenoughresource(CPUormemory)tospawnnewthreads.Action:Restartthewor...

IT技术学习 ·2023-07-28

ORA-30576: ConText Option dictionary loading error

文档解释ORA-30576:ConTextOptiondictionaryloadingerrorCause:ConTextdictionarytablesmaybecorruptedAction:notausererrorORA-30576这个错误是指，创建ConText选项字典时发生错误。官方解释常见案例一般处理方...

IT技术学习 ·2023-07-28

ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes

文档解释ORA-14640:add/coalesceindexpartitionoperationisvalidonlyforhashpartitionedglobalindexesCause:Userattemptedtoaddorcoalesceanindexpartitionofaglobalindexnotpa...

IT技术学习 ·2023-07-28

ORA-39781: Direct path stream loads are not allowed after another context loading the same table has ended

文档解释ORA-39781:DirectpathstreamloadsarenotallowedafteranothercontextloadingthesametablehasendedCause:Attempttoloadastreaminonecontextafteranotherloadingthesameta...

IT技术学习 ·2023-07-28

ORA-10906: Unable to extend segment after insert direct load

文档解释ORA-10906:UnabletoextendsegmentafterinsertdirectloadCause:Thisisarestrictionwithinsertdirectloadtransactions.Action:Whenasegmenthasbeeninsertdirectloaded,av...

IT技术学习 ·2023-07-27

ORA-39816: Direct Path Unload of tables with encrypted column(string.string) is not allowed.

文档解释ORA-39816:DirectPathUnloadoftableswithencryptedcolumn(string.string)isnotallowed.Cause:AnattemptwasmadetouseDirectPathAPIUnloadtounloadatablewithencryptedco...

IT技术学习 ·2023-07-27

ORA-39138: Insufficient privileges to load data not in your schema

文档解释ORA-39138:InsufficientprivilegestoloaddatanotinyourschemaCause:Anunprivilegeduserattemptedtoloaddataintoadifferentschema.Action:Useaprivilegedaccountifyoumu...

IT技术学习 ·2023-07-27