top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is Schema and Schema Objects in Oracle?

+1 vote
What is Schema and Schema Objects in Oracle?
posted Jul 1, 2015 by Vidhya Sagar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
Best answer

Schema is a collection of logical structure of data or Schema Objects. A Schema is owned by a database user and has the same name as that of user. Each user owns a single Schema.
Schema Objects include the following type of objects Clusters, Database Links, Tables, Indexes, Sequence, Synonyms, Views, Functions, Procedures, Database Triggers and Packages.

answer Jul 3, 2015 by Arun Gowda
Similar Questions
+2 votes

Which of the following is not a schema object: Indexes, tables, public synonyms, triggers and packages?

0 votes

If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure?