oracle實(shí)驗(yàn)一答案.doc

實(shí)驗(yàn)一 Oracle11g的常用工具和物理結(jié)構(gòu)一、實(shí)驗(yàn)?zāi)康呐c要求：1熟悉Oracle 11g中SQL*Plus工具的使用2掌握Oracle 11g的物理結(jié)構(gòu)3 熟悉相關(guān)數(shù)據(jù)字典的使用二、實(shí)驗(yàn)內(nèi)容：1以sys用戶登錄Oracle的SQL*PlusSQL*Plus: Release 11.2.0.1.0 Production on 星期五 9月 7 10:48:48 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.請(qǐng)輸入用戶名: sys as sysdba輸入口令:連接到:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options2對(duì)scott用戶解鎖SQL alter user scott account unlock 2 ;用戶已更改。SQL conn scott/123ERROR:ORA-01017: invalid username/password; logon denied更改 scott 的口令新口令:重新鍵入新口令:口令已更改已連接。SQL conn scott/123已連接。SQL3查詢sys用戶所登錄的數(shù)據(jù)庫名稱SQL select name from v$database;NAME-ORCL4查看Oracle的版本信息SQL select * from v$version;BANNER-Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionPL/SQL Release 11.2.0.1.0 - ProductionCORE 11.2.0.1.0 ProductionTNS for 32-bit Windows: Version 11.2.0.1.0 - ProductionNLSRTL Version 11.2.0.1.0 - Production5在Windows操作系統(tǒng)中找到數(shù)據(jù)文件、控制文件、日志文件，并記錄它們的位置以及文件名。SQL select name from v$datafile;NAME-E:APPJFORADATAORCLSYSTEM01.DBFE:APPJFORADATAORCLSYSAUX01.DBFE:APPJFORADATAORCLUNDOTBS01.DBFE:APPJFORADATAORCLUSERS01.DBFE:APPJFORADATAORCLEXAMPLE01.DBFSQL select name from v$controlfile;NAME-E:APPJFORADATAORCLCONTROL01.CTLE:APPJFFLASH_RECOVERY_AREAORCLCONTROL02.CTLSQL select group#,status from v$logfile; GROUP# STATUS- - 3 2 16在SQL*PLUS里利用數(shù)據(jù)字典查看數(shù)據(jù)文件、控制文件和日志文件的信息。SQL select * from v$datafile;SQL select * from v$controlfile; SQL select * from v$logfile;7查看日志文件組的當(dāng)前狀態(tài)SQL select group#,status from v$logfile; GROUP# STATUS- - 3 2 18切換日志文件，再查看日志文件組的當(dāng)前狀態(tài)SQL alter system switch logfile;系統(tǒng)已更改。SQL select group#,status from v$logfile; GROUP# STATUS- - 3 2 19顯示當(dāng)前數(shù)據(jù)庫的歸檔模式SQL select log_mode from v$database;LOG_MODE-NOARCHIVELOG10查看scott用戶的dept表的結(jié)構(gòu)SQLdesc scott.dept; 名稱 是否為空? 類型 - - - DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14) LOC VARCHAR2(13)11查看scott用戶的dept表的記錄SQL select * from scott.dept; DEPTNO DNAME LOC- - - 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON12以scott用戶登錄SQL*Plus，查看dept表的結(jié)構(gòu)和記錄SQL conn scott/123已連接。SQL desc dept; 名稱 是否為空? 類型 - - - DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14) LOC VARCHAR2(13)SQL select * from dept; DEPTNO DNAME LOC- - - 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON13如果要完全卸載Oracle數(shù)據(jù)庫，應(yīng)該怎么操作？a.開始運(yùn)行輸入“regedit”b.依次點(diǎn)擊HKEY_LOCAL_MACHINESOFTWAREORACLE 點(diǎn)右鍵刪除c. HKEY_LOCAL_MACHINESYSTE