oracle-家電服務(wù)公司管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)畢業(yè)論文(編輯修改稿)
2025-07-22 01:19 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 undo tablespace appliance_service_undo 2 datafile 39。I:\oracle\Disk4\39。 3 size 20m。表空間已創(chuàng)建。 4) 創(chuàng)建了一個(gè)位于 I:\oracle\Disk5 目錄下名為 appliance_service_index，大小為 10M 的索引表空間，每個(gè)區(qū)間的大小是 1M。SQL get 1 create tablespace appliance_service_index 2 datafile 39。I:\oracle\Disk5\39。 size 10m 3 extent management local 4* uniform size 1m。SQL start 表空間已創(chuàng)建。5) 完成創(chuàng)建表空間以后，要查看所建的表空間，輸入如下語(yǔ)句，得到如圖 21 結(jié)果，表明所有的表空間都已經(jīng)建立了。SQL select tablespace_name,contents from dba_tablespaces。TABLESPACE_NAME CONTENTS SYSTEM PERMANENTUNDOTBS1 UNDOSYSAUX PERMANENTTEMP TEMPORARYUSERS PERMANENTEXAMPLE PERMANENTAPPLIANCE_SERVICE PERMANENTAPPLIANCE_SERVICE_UNDO UNDOAPPLIANCE_SERVICE_TEMP TEMPORARYAPPLIANCE_SERVICE_INDEX PERMANENT已選擇 10 行。56) 為了不使 system 表空間碎片化，從而降低數(shù)據(jù)庫(kù)系統(tǒng)的效率，下一步就是要將臨時(shí)表空間設(shè)置為默認(rèn)臨時(shí)表空間。alter database default temporary tablespace appliance_service_temp。查看表空間SQL select property_name,property_value from database_properties 2 where property_name like 39。DEFAULT_TEMP%39。PROPERTY_NAME PROPERTY_VALUE DEFAULT_TEMP_TABLESPACE APPLIANCE_SERVICE_TEMP可以驗(yàn)證，已經(jīng)將 appliance_service_temp 設(shè)置為默認(rèn)臨時(shí)表空間7) 還原表空間的使用SQL alter system set undo_tablespace = appliance_service_undo。系統(tǒng)已更改。SQL get 1 select name,value 2 from v$parameter 3* where name like 39。%undo%39。SQL start NAME VALUE undo_management AUTOundo_tablespace APPLIANCE_SERVICE_UNDOundo_retention 900 創(chuàng)建表SQL get 1 create table 2 (svr_id number(8,0), 3 line_no number(4,0), 4 svh_date timestamp(6), 5 notes varchar2(4000), 6 svh_type varchar2(10), 7 created_by number(8,0)) 8* tablespace appliance_service。SQL start 6表已創(chuàng)建。SQL get 1 create table 2 (svr_id number(8,0), 3 status varchar2(20), 4 request_date timestamp(6), 5 problem_description varchar2(4000), 6 prod_id number(8,0), 7 created_by number(8,0), 8 assigned_to number(8,0)) 9* tablespace appliance_service。SQL start 表已創(chuàng)建。SQL get 1 create table 2 (prod_id number(8,0), 3 name varchar2(50), 4 image varchar2(4000), 5 description varchar2(4000)) 6* tablespace appliance_service。SQL start 表已創(chuàng)建。SQL get 1 create table 2 (user_id number(8,0), 3 user_role varchar2(10), 4 varchar2(50), 5 first_name varchar2(30), 6 last_name varchar2(30), 7 street_address varchar2(40), 8 city varchar2(30), 9 state_province varchar2(25), 10 postal_code varchar2(12), 11 country_id char(2)) 12* tablespace appliance_service。SQL start 表已創(chuàng)建。7SQL get 1 create table 2 (prod_id number(8,0), 3 user_id number(8,0), 4 expertise_level varchar2(30), 5 notes varchar2(4000)) 6* tablespace appliance_service。SQL start 表已創(chuàng)建。SQL select table_name from user_tables。TABLE_NAME USERS EXPERTISE_AREAS DEPT
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1