如题
最好举实际例,对段的操作之类的。
达人赐教
最好举实际例,对段的操作之类的。
达人赐教
解决方案 »
- linux下root用户连接oracle提示没有权限:insufficient privileges
- Oracle中如何设置不区分大小写啊?
- java程序界面验证用户登录,连接oracle数据库查询用户名及密码,登录时老是说用户名不对
- 关于数据库动态查询
- 左右连接
- 各位牛人帮忙设计下这个BT的树形表
- oracle包,函数,过程,游标的使用
- ****PLSQL Developer中编写的存储过程突然不能测试了,急
- 关于分组求和的问题?
- plsqldevelop 调试存储过程,单步执行 灰色 不能点,然后停止就卡了,存储过程肯定是没问题的
- 提问:用C++写的非常简单的数据库查询语句,求详细点的解释!
- 求助~~~如何保留归档日志
http://blog.csdn.net/minitoy/archive/2010/12/16/6080707.aspx
他展示数据库的对象在数据文件里的存储信息和存储的分配。DBA_SEGMENTS describes the storage allocated for all segments in the database.SQL> conn sys/myorcl as sysdba;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as SYS
-----刚开始没有我想创建的对象tiny.tests
SQL> select * from dba_segments r where r.owner = 'TINY' and r.segment_name = 'TESTS';OWNER SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE TABLESPACE_NAME HEADER_FILE HEADER_BLOCK BYTES BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS FREELIST_GROUPS RELATIVE_FNO BUFFER_POOL
------------------------------ -------------------------------------------------------------------------------- ------------------------------ ------------------ ------------------------------ ----------- ------------ ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------------- ------------ -----------SQL> create table tiny.tests(id number);Table createdSQL> select * from dba_segments r where r.owner = 'TINY' and r.segment_name = 'TESTS';OWNER SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE TABLESPACE_NAME HEADER_FILE HEADER_BLOCK BYTES BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS FREELIST_GROUPS RELATIVE_FNO BUFFER_POOL
------------------------------ -------------------------------------------------------------------------------- ------------------------------ ------------------ ------------------------------ ----------- ------------ ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------------- ------------ -----------
TINY TESTS TABLE USERS 4 793 65536 8 1 65536 1 2147483645 1 1 4 DEFAULTSQL> drop table tiny.tests;Table droppedSQL> select * from dba_segments r where r.owner = 'TINY' and r.segment_name = 'TESTS';OWNER SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE TABLESPACE_NAME HEADER_FILE HEADER_BLOCK BYTES BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS FREELIST_GROUPS RELATIVE_FNO BUFFER_POOL
------------------------------ -------------------------------------------------------------------------------- ------------------------------ ------------------ ------------------------------ ----------- ------------ ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------------- ------------ -----------SQL>