--刪除用戶 drop user sz cascade; --創(chuàng)建表空間 create tablespace worktablsp datafile 'C:\app\lenovo\oradata\orcl\EMPTB.dbf' SIZE 5MAUTOEXTEND ON; --修改表空間 ALTER tablespace worktablsp ADD datafile 'C:\app\lenovo\oradata\orcl\EMPTB.dbf' SIZE 5M;--擴(kuò)展數(shù)據(jù)文件大小ALTER database datafile 'C:\app\lenovo\oradata\orcl\EMPTB.dbf' RESIZE 6M;--刪除DROP TABLESPACE worktablsp INCLUDING CONTENTS and datafiles --創(chuàng)建用戶: CREATE USER RH IDENTIFIED BY HR DEFAULT TABLESPACE tablespace ;--給用戶授權(quán):GRANT CONNECT TO RH; --連接數(shù)據(jù)庫角色 GRANT SELECT ON SCOTT.EMP TO RH;--查看SCOTT.EMP表的權(quán)限--分區(qū)表--范圍分區(qū)create table saletb(saleid number ,productid number,saleDate date not null)partition by range(saleDate)(partition p1 values less than(to_date('2013-01-01','yyyy-mm-dd')),partition p2 values less than(to_date('2014-01-01','yyyy-mm-dd')),partition p3 values less than(to_date('2015-01-01','yyyy-mm-dd')),partition p4 values less than(maxvalue) );select * from saletb;insert into saletb values(1,1,to_date('2012-01-01','yyyy-mm-dd'));insert into saletb values(2,2,to_date('2013-06-01','yyyy-mm-dd'));insert into saletb values(3,3,to_date('2014-10-01','yyyy-mm-dd'));insert into saletb values(4,4,to_date('2016-01-01','yyyy-mm-dd'));select * from saletb partition(p3);--間隔分區(qū) 一個(gè)季度（三個(gè)月）一個(gè)分區(qū)CREATE TABLE SALES2 (SALES_ID NUMBER,PRODUCT_ID VARCHAR2(5),SALES_DATE DATE NOT NULL )PARTITION BY RANGE(SALES_DATE)INTERVAL(NUMTOYMINTERVAL(3,'MONTH'))(PARTITION P1 VALUES LESS THAN (to_date('2013-04-1','yyyy/mm/dd')));--select * from sales2; --插入數(shù)據(jù)INSERT INTO sales2 VALUES (1,'a',to_date('2013-08-1','yyyy/mm/dd'));INSERT INTO sales2 VALUES (3,'c',to_date('2013-02-1','yyyy/mm/dd'));--查看分區(qū)數(shù)據(jù)select * from sales2 partition(sys_p41);--獲得分區(qū)情況SELECT table_name,partition_name FROM user_tab_partitions WHERE table_name=UPPER('sales2');
創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎(jiǎng)勵(lì)來咯，堅(jiān)持創(chuàng)作打卡瓜分現(xiàn)金大獎(jiǎng)

總結(jié)

以上是生活随笔為你收集整理的Oracle数据库基本概念理解（2）的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。