cancel
Showing results for 
Search instead for 
Did you mean: 

schema object

SOLVED
Go to solution
HPADM
Advisor

schema object

Hi,
I would like to understand what is a schema object so I tried to do one:

I have done:

SQL> select tablespace_name,EXTENT_MANAGEMENT from dba_tablespaces;

TABLESPACE_NAME EXTENT_MAN
------------------------------ ----------
SYSTEM DICTIONARY
TOOLS DICTIONARY
RBS DICTIONARY
TEMP DICTIONARY
USERS DICTIONARY
INDX DICTIONARY
DRSYS DICTIONARY
PROVA DICTIONARY
PROVA_LOCAL LOCAL
corso1 DICTIONARY

create user "andrea" profile "DEFAULT" identified by "avellino17"
2 default tablespace "PROVA_LOCAL" temporary tablespace "TEMP" account unlock;

grant connect to andrea;


Did I create a schema object for andrea user?

4 REPLIES
Ian Lochray
Respected Contributor

Re: schema object

Here is an extract from the Oracle documentation. As you will see, the answer to your question is yes and no. You have created an object but not a schema object.
Database Objects
Oracle recognizes objects that are associated with a particular schema and objects that are not associated with a particular schema, as described in the sections that follow.

Schema Objects
A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL and include the following types of objects:

Clusters

Database links

Database triggers

Dimensions

External procedure libraries

Index-organized tables

Indexes

Indextypes

Java classes, Java resources, Java sources

Materialized views

Materialized view logs

Object tables

Object types

Object views

Operators

Packages

Sequences

Stored functions, stored procedures

Synonyms

Tables

Views

Nonschema Objects
Other types of objects are also stored in the database and can be created and manipulated with SQL but are not contained in a schema:

Contexts

Directories

Profiles

Roles

Rollback segments

Tablespaces

Users

HPADM
Advisor

Re: schema object

great Ian!!
HPADM
Advisor

Re: schema object

what kind of select can I use to see the schema object of a user?
Is it possible?
Ian Lochray
Respected Contributor
Solution

Re: schema object

log on to sqlplus as the user and select from the user_objects table i.e.
sqlplus scott/tiger
select object_name, object_type from user_objects;
alternately you can log on to sqlplus as the system user and query the all_objects table i.e.
select object_name, object_type from all_objects where owner = 'SCOTT';