INSERTPurposeUsetheINSERTstatementtoaddrowstoatable,thebasetableofaview,apartitionofapartitionedtableorasubpartitionofacomposite-partitionedtable,oranobjecttableorthebasetableofanobjectview.AdditionalTopicsHYPERLINK"http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9014.htm"\l"i2063953"PrerequisitesHYPERLINK"http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9014.htm"\l"i2111652"SyntaxHYPERLINK"http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9014.htm"\l"i2145420"SemanticsHYPERLINK"http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9014.htm"\l"i2145081"ExamplesPrerequisitesForyoutoinsertrowsintoatable,thetablemustbeinyourownschemaoryoumusthavetheINSERTobjectprivilegeonthetable.Foryoutoinsertrowsintothebasetableofaview,theowneroftheschemacontainingtheviewmusthavetheINSERTobjectprivilegeonthebasetable.Also,iftheviewisinaschemaotherthanyourown,thenyoumusthavetheINSERTobjectprivilegeontheview.IfyouhavetheINSERTANYTABLEsystemprivilege,thenyoucanalsoinsertrowsintoanytableorthebasetableofanyview.ConventionalandDirect-PathINSERTYoucanusetheINSERTstatementtoinsertdataintoatable,partition,orviewintwoways:conventionalINSERTanddirect-pathINSERT.WhenyouissueaconventionalINSERTstatement,OracleDatabasereusesfreespaceinthetableintowhichyouareinsertingandmaintainsreferentialintegrityconstraints.Withdirect-pathINSERT,thedatabaseappendstheinserteddataafterexistingdatainthetable.Dataiswrittendirectlyintodatafiles,bypassingthebuffercache.Freespaceintheexistingdataisnotreused.ThisalternativeenhancesperformanceduringinsertoperationsandissimilartothefunctionalityoftheOracledirect-pathloaderutility,SQL*Loader.Whenyouinsertintoatablethathasbeencreatedinparallelmode,direct-pathINSERTisthedefault.Themannerinwhichthedatabasegeneratesredoandundodatadependsinpartonwhetheryouareusingconventionalordirect-pathINSERT:ConventionalINSERTalwaysgeneratesmaximalredoandundoforchangestobothdataandmetadata,regardlessofthelo