DBA_ASSEMBLIES

DBA_ASSEMBLIES provides information about all assemblies in the database. Its columns are the same as those in ALL_ASSEMBLIES.

Related Views

· ALL_ASSEMBLIES provides information about assemblies accessible to the current user.

· USER_ASSEMBLIES provides information about all assemblies owned by the current user. This view does not have the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the assembly
ASSEMBLY_NAME	VARCHAR2(30)	NOT NULL	Name of the assembly
FILE_SPEC	VARCHAR2(4000)		Operating system file specification of the assembly
SECURITY_LEVEL	VARCHAR2(10)		The maximum security level of the assembly
IDENTITY	VARCHAR2(4000)		The identity of the assembly
STATUS	VARCHAR2(7)		Status of the assembly

Oracle data dictionary views

Oracle dynamic performance views