易截截图软件、单文件、免安装、纯绿色、仅160KB

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


相关文档:

oracle压力测试之orastress!


orastress主要测试数据库的压力。它可以测试数据库的CPU或者内存的压力(以只读方式),也可以使用包括普通INSERT和直接路径INSERT两种方式测试数据库的I/O能力。
orastress只能运行在windows下,但它也可以测试远程服务器的压力。
1、下载
下载地址是
http://www.linxcel.co.uk/orabm/orastress.zip
2、安装
oras ......

Oracle中截取字符串

关于Oracle里面的一些小函数
要求:A.数据库表中的一个字符串  可能含有"+" 例:ORC+001
       也可能不含“+”
      B.要求如果该字符串含有“+”,则取“+”之前的字符 例:ORC+001 取ORC
     ......

.net在web.config中连接oracle数据库

1.asp.net连接oracle服务器需要添加Sytem.Data.OracleClient命名空间,将System.Data.OracleClient.dll加入到项目中。
2.连接时需要ConnectionString字符串,出现在web.config文件中,如下所示:
<connectionStrings>
   <add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=( ......

oracle uptime的bug

症状:oracle sqlplus没反应
oracle10g的有十几个机器客户端10.2.0.1.0,执行sqlplus这个命令没反映。此时cpu使用为99.9%,观察了一会,不释放。
oracle其他命令都好使。
环境变量、ping tnsname等都没问题。。且这些机器都是至少运行了200多天左右,
但一旦重启OS就好使了。。
或者不重启OS,换成9i的客户端,sqlplus ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号