- 浏览: 25815 次
- 性别:
- 来自: 北京
最新评论
A schema is a collection of database objects owned by a specific database user,or schema objects.Schema has the same name as that user,every user has a single schema,so the two terms(Schema,User) are synonymous.
Schema objects include the segments(tables,indexes..etc) as we can see in the tablespaces as well as the nosegments database objects(constraints,views,procedures,synonyms and packages).But the roles,tablespaces,profiles and directories are not schema objects,cause they are not owned by one specific user.
In a word,if any object(table,view,index…) owned by one user,it’s schema object.Contrarily,the role,profile,tablespace and directory (not owned by one user) are not schema objects.
Note:
There is no relationship between schemas and tablespaces: a tablespace can contain objects from different schemas,and the objects for a schema can be contained in different tablespaces
发表评论
-
from string get number data using pl/sql or sql
2012-02-16 17:32 849declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 6761.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7491.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 841thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7061.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 760Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 6501.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7101.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11161.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5321.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6121.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 701When we COMMIT, all that is lef ... -
MANAGE UNDOTABS
2011-12-19 17:15 6501.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4101.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7551.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5361. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6541.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 8671.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 623ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6071.utl_file_dir: indicate the di ...
相关推荐
(a) filling in skeleton tables of the database with examples of what is to be retrieved (b) placing SQL keywords, such as select, under the column names they want to retrieve (c) typing a ...
What Is the OEM? The DBA Toolkit and Security OEM and the Job Scheduler OEM and the Event Management System Chapter 14 Maintaining User Accounts Application Design Requirements Running the ...
GraphQL Java implementation. It requires a little Spring and Java knowledge.... The schema describes what queries are possible and what fields you can get back. (Note: when we refer to
The overall design of the database is called the database schema. The physical schema describes the database design at the physical level, while the logical schema describes the database design at the...
2.1.1 What is a Data Model? 2.1.2 Important Data Models 2.1.3 The Relational Model in Brief 2.1.4 The Semistructured Model in Brief 2.1.5 Other Data Models 2.1.6 Comparison of Modeling ...
package and see what is inside it. After that, we will learn how to install the "illuminate/database" package separately for your project and how to configure it for its first use. Yes, exactly: ...
More specifically, developers need to store objects as loose collections of schema-less documents, but those same developers also need the ability to run structured queries on their data. With MySQL ...
The second data model is shared database, separate schema in which houses multiple users in the same database, with each user having his own set of tables that are grouped into a schema created ...
Another type of table lock is a schema stability lock (Sch-S) and is compatible with all table locks except the schema modification lock (Sch-M). The schema modification lock (Sch-M) is incompatible ...
jsonschema jsonschema是Python的实现。 >> > from jsonschema import validate >> > # A sample schema, like ...>> > # If no exception is raised by validate(), the instance is valid. >> > validate ( instan
The only source of any storage location information is the sysindexes table, which keeps track of the address of the root page for every index, and the first IAM page for the index or table....
What Is a Schema/DTD? 278 What Are Document Models For? 278 Do You Need One? 278 Document Type Definitions 278 An Example DTD 278 DTDs Aren’t Exactly XML 280 Limitations of DTDs 280 Schemas ...
(b) Starting with the base cuboid [date, spectator, location, game],what specific OLAP operations should one perform in order to list the total charge paid by student spectators in Los Angeles?...
Drupal is an award-winning open-source Content Management System, and the feature-packed sixth release is right around the corner. It's a modular system, with an elegant hook-based architecture, and ...
The is Operator 135 The as Operator 136 The sizeof Operator 136 The typeof Operator 136 Contents Operator Precedence 137 Type Safety 137 Type Conversions 138 Boxing and Unboxing 141 Comparing Objects ...
I enhanced the statement processing logic so that it detects a DDL statement and causes the schema cache data to be invalidated so that all DDL statements are immediately recognized in how they impact...
relationships and the database schema they map to whether you use Code First to help create a database or you want to use it with an existing database With this knowledge you can reap the benefits of...
The trick is getting the whole village together. This book shows you how. About the Book Irresistible APIspresents a process to create APIs that succeed for all members of the team. In it, you'll ...
Examining the Schema and Properties of the Database Class Adding Data to MySQL with WordPress Retrieving Data from MySQL with WordPress Preventing SQL Injection Summary Chapter 8: Dissecting the Loop ...