What Is The Difference Between Internal And External Lobs?

1.	What Is The Difference Between Internal And External Lobs?
Answer» LOB datatype can be internal or external. Internal LOBS are CLOB, NCLOB, and BLOB that are stored in the database; WHEREAS, external LOBs are BFILEs that are stored outside the database as external files. Although both LOB types have the pointer to the LOCATION, the BFILEs are stored EXTERNALLY across hard disks or on external storage; whereas, internal LOBs have to be stored in the different location within the database itself. LOB datatype can be internal or external. Internal LOBs are CLOB, NCLOB, and BLOB that are stored in the database; whereas, external LOBs are BFILEs that are stored outside the database as external files. Although both LOB types have the pointer to the location, the BFILEs are stored externally across hard disks or on external storage; whereas, internal LOBs have to be stored in the different location within the database itself.

Answer»

LOB datatype can be internal or external. Internal LOBS are CLOB, NCLOB, and BLOB that are stored in the database; WHEREAS, external LOBs are BFILEs that are stored outside the database as external files. Although both LOB types have the pointer to the LOCATION, the BFILEs are stored EXTERNALLY across hard disks or on external storage; whereas, internal LOBs have to be stored in the different location within the database itself.

LOB datatype can be internal or external. Internal LOBs are CLOB, NCLOB, and BLOB that are stored in the database; whereas, external LOBs are BFILEs that are stored outside the database as external files. Although both LOB types have the pointer to the location, the BFILEs are stored externally across hard disks or on external storage; whereas, internal LOBs have to be stored in the different location within the database itself.

Discussion

No Comment Found

Related InterviewSolutions

Do Stored Procedures And Functions Within The Same Schema Share The Same Namespace?
Give A Sql Statement So That The Procedure Proc_1 In The Package Pack_sample Is Granted Access To All The Users In The Database ?
Give A Sql Statement To Grant Access On The Procedure Proc_sample In The Schema, Schema_a.
Is It Possible To Create A Package Body And Store It In A Database?
Give The Sql Statement To Drop The Package Specification For Pack_a Without Dropping The Package Body ?
Suppose A Procedure Proc_1 Refers To A Procedure Proc_2 Within The Pack_1 Package. If The Definition Of The Proc_2 Procedure Is Changed And It Is Recompiled Again, Then Does The Proc_1 Procedure Is Invalidated ?
Explain The Grant And Revoke Dcl Statements ?
Which Data Dictionary View Will Give The Owner Name Along With The Privileges On A Schema Object?
Which Column In The User_sys_privs View Determines Whether The System Privilege Is With Admin Option ?
Write A Pl/sql Statement To Show The Privileges On A Procedure Proc_1 Within The Schema A ?