Difference between a user and a schema in Oracle?

by

From Ask Tom

You should consider a schema to be the user account and collection of all objects therein
as a schema for all intents and purposes.

SCOTT is a schema that includes the EMP, DEPT and BONUS tables with various grants, and
other stuff.

SYS is a schema that includes tons of tables, views, grants, etc etc etc.

SYSTEM is a schema…..

Technically — A schema is the set of metadata (data dictionary) used by the database,
typically generated using DDL. A schema defines attributes of the database, such as
tables, columns, and properties. A database schema is a description of the data in a
database.

More Related Contents:

  1. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  2. How do I escape a reserved word in Oracle?
  3. How to put more than 1000 values into an Oracle IN clause [duplicate]
  4. ORA-30926: unable to get a stable set of rows in the source tables
  5. How to best split csv strings in oracle 9i
  6. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
  7. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  8. Using the “IN” clause with a comma delimited string from the output of a replace() function in Oracle SQL
  9. NLS_NUMERIC_CHARACTERS setting for decimal
  10. Oracle JDBC and Oracle CHAR data type
  11. Does Oracle have an equivalent of SQL Server’s table variables?
  12. Reason why oracle is case sensitive?
  13. ORA-12170: TNS:Connect timeout occurred
  14. Faster alternative in Oracle to SELECT COUNT(*) FROM sometable
  15. How to create and use temporary table in oracle stored procedure?
  16. Oracle date difference to get number of years
  17. SQL*Plus how to accept text variable from prompt?
  18. How to find difference b/w TIMESTAMP format values in Oracle?
  19. SQL Fiddle Output Error
  20. oracle PL/SQL how to calculate range ip for IPv6 cidr
  21. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  22. Oracle: how to add minutes to a timestamp?
  23. How to drop multiple interval partitions based on date?
  24. How to list active / open connections in Oracle?
  25. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  26. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  27. How to Register Pluggable Database(PDB) with new created LISTENER
  28. return resultset from function
  29. Grant Select on all Tables Owned By Specific User
  30. ORA-12704: character set mismatch

Leave a Comment