Oracle数据库基本知识及问题解决

CREATE TABLESPACE test DATAFILE '/dev/test_name1' SIZE
1000M, '/dev/test_name2' SIZE 1000M , '/dev/test_name3' SIZE 1000M 
      DEFAULT STORAGE ( INITIAL 64K NEXT 64K MAXEXTENTS UNLIMITED PCTINCREASE 50 ); 
网管u家u.bitsCN.com
 

alter TABLESPACE ts_name1 add DATAFILE '/dev/name4' SIZE 1000M; 
网管网www_bitscn_com
 

CREATE ROLLBACK SEGMENT "RStest" TABLESPACE "Test_name" 
      STORAGE ( INITIAL 16M NEXT 16M MAXEXTENTS UNLIMITED); 中国网管联盟bitsCN.com 

CREATE USER test_user IDENTIFIED BY test_user 
DEFAULT TABLESPACE Test_name1 TEMPORARY TABLESPACE Test_name2; 
GRANT CONNECT TO test_user; 
GRANT DBA TO test_user; 
      GRANT resource TO test_user; 
网管论坛bbs_bitsCN_com
 

create table test_name1
( 
a NUMBER(10) not null, 
b NUMBER(10) null , 
c NUMBER(3) defalut 0, 
d number(3) not null , 
constraint PK_ test_user primary key (a) 
using index 
tablespace test_name1 
storage
( 
initial 1m 
next 1m 
pctincrease 0 
) 
) 
pctfree 10 
tablespace test_name1 
storage 
( 
initial 1m 
next 1m 
pctincrease 0 
) 
partition by range(d) 
(partition part000 values less than (1) tablespace test_name1, 
partition part001 values less than (2) tablespace test_name1, 
      ) 
网管网www_bitscn_com
 

create index id_tablename1 on test_name1 (f2) 
tablespace ts_name 
storage 
(　 
initial 500k 
next 500k 
pctincrease 0 
      ) 
网管论坛bbs_bitsCN_com
 

select substr(a.TABLESPACE_NAME,1,10) TablespaceName, 
sum(a.bytes/1024/1024) totle_size, 
sum(nvl(b.free_space1/1024/1024,0)) free_space, 
sum(a.bytes/1024/1024)-sum(nvl(b.free_space1/1024/1024,0)) used_space, 
round((sum(a.bytes/1024/1024)-sum(nvl(b.free_space1/1024/1024,0)))*100/sum
(a.bytes/1024/1024),2) used_percent 
from dba_data_files a, 
(select sum(nvl(bytes,0)) free_space1,file_id 
from dba_free_space 
group by file_id) b 
where a.file_id = b.file_id(+) 
      group by a.TABLESPACE_NAME 网管u家u.bitscn@com