Oracle Schema Objects
Introduction to 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
Indexes and index types
Java classes, Java resources, and Java sources
Materialized views and materialized view logs
Object tables, object types, and object views
Operators
Sequences
Stored functions, procedures, and packages
Synonyms
Tables and index-organized tables
Views
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
Tablespaces
Users
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10743/schema.htm#i5669
Ïà¹ØÎĵµ£º
Êý¾Ý¿âѹÁ¦²âÊÔ
Ò»¡¢ÓÃorabm²âÊÔÊý¾Ý¿âCPU
Orabmͨ¹ýÔÚÓû§Ö¸¶¨µÄ²¢·¢ÏÂÔËÐÐÖ¸¶¨ÊýÁ¿µÄÊÂÎñÀ´²âÊÔϵͳÐÔÄÜ.ËüÖ÷Òª²âÊÔÊý¾Ý¿â·þÎñÆ÷µÄCPUÐÔÄܺÍÄÚ´æ¡£
orabmʵ¼ÊÉÏÊÇÒ»¶ÑsqlµÄ¼¯ºÏ¡£
orabm¿ÉÒÔÓÃÔÚlinux/windows/solarisÏÂʹÓá£
orabm²»Ò»¶¨ÐèÒªÔËÐÐÔÚÊý¾Ý¿âËùÔÚ·þÎñÆ÷ÉÏ£¬Ëü¿ÉÒÔÔËÐÐÔÚÈκΰ²×°ÁË9i¿Í»§¶ËµÄÖÕ¶ËÉÏ¡£Äã ......
orastressÖ÷Òª²âÊÔÊý¾Ý¿âµÄѹÁ¦¡£Ëü¿ÉÒÔ²âÊÔÊý¾Ý¿âµÄCPU»òÕßÄÚ´æµÄѹÁ¦£¨ÒÔÖ»¶Á·½Ê½£©£¬Ò²¿ÉÒÔʹÓðüÀ¨ÆÕͨINSERTºÍÖ±½Ó·¾¶INSERTÁ½ÖÖ·½Ê½²âÊÔÊý¾Ý¿âµÄI/OÄÜÁ¦¡£
orastressÖ»ÄÜÔËÐÐÔÚwindowsÏ£¬µ«ËüÒ²¿ÉÒÔ²âÊÔÔ¶³Ì·þÎñÆ÷µÄѹÁ¦¡£
1¡¢ÏÂÔØ
ÏÂÔØµØÖ·ÊÇ
http://www.linxcel.co.uk/orabm/orastress.zip
2¡¢°²×°
oras ......
OracleÖ±·½Í¼½âÎö
Ò»¡¢ ºÎνֱ·½Í¼£º
Ö±·½Í¼ÊÇÒ»ÖÖͳ¼ÆÑ§ÉϵŤ¾ß£¬²¢·ÇOracleרÓС£Í¨³£ÓÃÓÚ¶Ô±»¹ÜÀí¶ÔÏóµÄij¸ö·½ÃæµÄÖÊÁ¿Çé¿ö½øÐйÜÀí£¬Í¨³£Çé¿öÏÂËü»á±íÏÖΪһÖÖ¼¸ºÎͼÐÎ±í£¬Õâ¸öͼÐαíÊǸù¾Ý´Óʵ¼Ê»·¾³ÖÐËùÊÕ¼¯À´µÄ±»¹ÜÀí¶ÔÏóij¸ö·½ÃæµÄÖÊÁ¿·Ö²¼Çé¿öµÄÊý¾ÝËù»æÖƳɵģ¬Í¨³£»á»³ÉÒÔÊýÁ¿Îªµ×±ß£¬ÒÔÆ ......
¹ØÓÚOracleÀïÃæµÄһЩСº¯Êý
ÒªÇó£ºA.Êý¾Ý¿â±íÖеÄÒ»¸ö×Ö·û´® ¿ÉÄܺ¬ÓÐ"+" Àý£ºORC+001
Ò²¿ÉÄܲ»º¬“+”
B.ÒªÇóÈç¹û¸Ã×Ö·û´®º¬ÓГ+”£¬ÔòÈ¡“+”֮ǰµÄ×Ö·û Àý£ºORC+001 È¡ORC
  ......
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖÆ²éѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄÃû³Æ×÷Ϊǰ׺¡£
¾ÙÀý˵Ã÷£º
ÀýÈç±í£ºstudent(ѧÉú)±í£¬±í½á¹¹Îª£º
ID¡¡¡¡¡¡ char(6)¡¡¡¡¡¡¡¡¡¡ --ѧºÅ
name¡¡¡¡ ......