DBA_OBJECTS is an Oracle data dictionary view that lists every object in the entire database — tables, views, indexes, sequences, procedures, packages, triggers, synonyms, etc. — across all schemas and all these were managed by DBA. Core Oracle database objects Object Purpose Table Stores application data in rows and columns Index Improves query performance by providing faster access paths View Virtual table based on a SQL query Materialized View Stores the result of a query physically and can be refreshed Sequence Generates unique numeric values, commonly for primary keys Synonym Provides an alternate name for another object Database Link Allows SQL access to objects in another Oracle database User / Schema A user owns a schema containing database objects Procedure Stored PL/SQL program used to perform operations Function Stored PL/SQL program that returns a value Package Groups related procedures, functions, variables, and types Trigger Automatically executes PL/SQL in response...
A database schema is like a blueprint that defines how data is organized and stored in a database . It describes the structure of tables, columns, data types, relationships, constraints, and indexes, providing a clear framework for how different pieces of data are stored and connected. 🔑 Key Points Schema = Structure → Defines tables, columns, and rules. Ensures consistency → Data must follow the schema (e.g., a column defined as INT cannot store text). Relationships → Specifies how tables connect (foreign keys, primary keys). Constraints → Rules like NOT NULL , UNIQUE , CHECK .