1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
  4. ALL_ASSEMBLIES

2.47 ALL_ASSEMBLIES

ALL_ASSEMBLIES provides information about assemblies accessible to the current user.

Related Views

  • 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 display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the assembly

ASSEMBLY_NAME

VARCHAR2(128)

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: