ALL_ASSEMBLIES provides information about assemblies accessible to the current user.
DBA_ASSEMBLIES provides information about all assemblies in the database.
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 |
See Also: