- 浏览: 27146 次
- 性别:
- 来自: 北京
-
最新评论
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 888declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 7241.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7911.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 878thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7531.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 798Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 7031.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7481.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11951.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5671.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6421.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 738When we COMMIT, all that is lef ... -
MANAGE UNDOTABS
2011-12-19 17:15 6781.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4361.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7881.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5761. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6851.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 9031.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 653ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6341.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
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 ...
- **Shared Memory:** This protocol is used for local connections where the client and server applications run on the same machine. It is faster than Named Pipes and TCP/IP but is limited to local ...
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....
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...
All you need to do is create an XML file that conforms to the schema above, then bundle that XML file with your JAR. Some notes on where you put that file in the JAR: it cannot go in the default ...
This Is Not My Beautiful Relational Schema! 152 7.Publishing Semantic Data .............................................. 155 Embedding Semantics 155 Table of Contents|vii Download at Boykma.Com ...
Models: designing an initial database schema 31 The link data model 32 The user data model 35 The bookmark data model 36 Templates: creating a template for the main page 38 Putting it all ...