【正文】 數(shù)據(jù)庫對象V$Content$nbsp?？梢躁P(guān)連多個(gè)表及用集合函數(shù)生成新表,注意選擇出來的字段必須有合法的字段名稱,且不能重復(fù)。字符大小寫敏感，日期格式敏感。grant select, insert on to DATA_ENTRY_CLERK。grant CREATE SESSION to APPLICATION_USER。alter user jane password expire。grant CREATE SESSION to JANE。alter user THUMPER default role all except ACCOUNT_CREATOR。//用戶和角色create role ACCOUNT_CREATOR。//例子set transaction use rollback segment SEGMENT_NAME alter tablespace RBS default storage(initial 125K next 125K minextents 18 maxextents 249)create rollback segment R4 tablespace RBS storage(optimal 2250K)。//查詢回滾段的 大小和優(yōu)化參數(shù) select * from DBA_SEGMENTS where Segment_Type = ’ROLLBACK’。//回滾段上指定事務(wù) mit。//回滾段的管理create rollback segment SEGMENT_NAME tablespace RBS。alter database datafile ’/db05/oracle/CC1/’ resize 80M。//修改參數(shù): alter database datafile ’/db05/oracle/CC1/’ autoextend ON maxsize 300M。alter user USERNAME temporary tablespace TEMP。alter user USERNAME default tablespace TABLESPACE_NAME。alter database add logfile member ’/db03/oracle/CC1/’ to group 4。REM REM Exit Server Manager using the indicator set EOFarch1 Step 2: Record which files are in the destination directory. Do this by setting an environment variable that is equal to the directory listing for the destination directory. For this example, the log_archive_dest is /db01/oracle/arch/CC1. FILES=`ls /db01/oracle/arch/CC1/arch*.dbf`。exit EOFarch2 Now back up the archived redo logs to the tape device via the “tar” mand, then delete them from the destination device via the “rm” mand. You may choose to press them instead. tarrvf /dev/rmt/0hc $FILES rmf $FILES Step . svrmgrl connect internal alter database backup controlfile to ’db01/oracle/CC1/’。REM REM 備份 TEMP tablespace REM alter tablespace TEMP begin backup。REM REM 備份 DATA tablespace REM For the purposes of this example, this tablespace REM will contain two files, and The * wildcard will be used in the alter tablespace DATA begin backup。export svrmgrl connect internal as sysdba REM REM 備份 SYSTEM tablespace REM alter tablespace SYSTEM begin backup。alter database open。 scope=spfile。archive log list alter system set LOG_ARCHIVE_DEST_1=39。exit EOF1 insert backup mands like the “tar” mands here svrmgrl connect internal as sysdba startup EOF2 //在Server Manager上設(shè)置為archivelog mode: connect internal as sysdba startup mount cc1。00%39。alter user OPS$FARMER identified by VALUES ’no way’。grant SELECT on EMPLOYEE to MCGREGOR with grant option。//回收權(quán)利: revoke delete on EMPLOYEE from PETER。grant DATA_ENTRY_CLERK to MCGREGOR。grant select, insert on to DATA_ENTRY_CLERK。REM Using identified externally create user OPS$FARMER identified externally default tablespace USERS temporary tablespace TEMP。alter user JANE account lock。create profile LIMITED_PROFILE limit FAILED_LOGIN_ATTEMPTS 5。alter user THUMPER default role NONE。select Sessions_Highwater from V$LICENSE。//回收回滾段alter rollback segment R1 shrink to 15M。insert into TABLE_NAME select * from DATA_LOAD_TABLE。drop rollback segment SEGMENT_NAME。grant CREATE SESSION to APPLICATION_USER。alter tablespace DATA rename datafile ’/db01/oracle/CC1/’ to ’/db02/oracle/CC1/’。//創(chuàng)建一個(gè)自動擴(kuò)展的數(shù)據(jù)文件: create tablespace DATA datafile ’/db05/oracle/CC1/’ size 200M autoextend ON next 10M maxsize 250M。alter user SYSTEM quota 50M on TOOLS。alter database open。select sum(Successcount)from tbl_MiddleMt0411 where ServiceType2=111 select sum(successcount),servicetype from tbl_middlemt0411 group by servicetype原文地址：alter database backup controlfile to trace。查詢數(shù)據(jù)庫中第63號錯(cuò)誤：select orgaddr,destaddr from sm_histable0116 where error_code=39。GRANT SELECT, INSERT, DELETE ON表名 TO 用戶名1, 用戶名2。 SIZE 20M REUSE AUTOEXTEND ON MAXSIZE UNLIMITEDMartriWang 10/05/2007emctl start dbconsole emctl stop dbconsole://servername:port/empath:$ORACLE_HOME/install/ isqlplusctl start isqlplusctl stop://servername:port/isqlplus 數(shù)據(jù)庫連接字符串可以用NET8 EASY =true時(shí)要求數(shù)據(jù)庫鏈接名稱跟遠(yuǎn)端數(shù)據(jù)庫名稱一樣 數(shù)據(jù)庫全局名稱可以用以下命令查出 SELECT * FROM GLOBAL_NAME。 SIZE 325M REUSE DEFAULT TABLESPACE tbs_1 DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE 39。)SIZE 100M MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXINSTANCES 100 MAXINSTANCES 1 CHARACTER SET US7ASCIINATIONAL CHARACTER SET AL16UTF16 DATAFILE 39。)SIZE 100M, GROUP 2(39。CREATE SYNONYM同義詞名FOR 表名數(shù)據(jù)庫鏈接名。analyze index indexname pute statistics。Create index indexname on tablename(columnname[columnname...])reverse（3）降序索引。字符串模糊比較的方法INSTR(字段名, ‘字符串’)0 字段名 LIKE ‘字符串%’ [‘%字符串%’] 每個(gè)表都有一個(gè)隱含的字段ROWID, (SCHEMA)(INDEX)CREATE INDEX 索引名ON 表名(字段1, [字段2, ……])。兩個(gè)查詢語句的結(jié)果可以做集合操作例如: 并集UNION(去掉重復(fù)記錄), 并集UNION ALL(不去掉重復(fù)記錄), 差集MINUS, 交集INTERSECT 分組查詢SELECT字段名1, 字段名2, …… FROM 表名1, [表名2, ……] GROUP BY字段名1 [HAVING 條件]。(SELECT)部分SELECT字段名1, 字段名2, …… FROM 表名1, [表名2, ……] WHERE 條件。把表放在或取出數(shù)據(jù)庫的內(nèi)存區(qū) ALTER TABLE 表名 CACHE。在表的后面增加一個(gè)字段ALTER TABLE表名 ADD 字段名 字段名描述。注意：, 可以用 TRUNCATE 命令, 它可以釋放占用的數(shù)據(jù)塊表空間TRUNCATE TABLE 表名。字符串類型的字段值必須用單引號括起來, 例如: ’GOOD DAY’如果字段值里包含單引號’ 需要進(jìn)行字符串轉(zhuǎn)換, 我們把它替換成兩個(gè)單引號39。INSERT INTO 表名(字段名1, 字段名2, ……)SELECT(字段名1, 字段名2, ……)FROM 另外的表名。其中最大的值按字段的長度來定, 如果定義的自動增長的序列號 NUMBER(6), 最大值為999999 INSERT 語句插入這個(gè)字段值為: (刪除數(shù)據(jù)表里記錄的語句)DELETE FROM表名 WHERE 條件。值N超過定義的長度會出錯(cuò), 最好在插入前進(jìn)行長度校驗(yàn)..注意事項(xiàng): , 確認(rèn)完成后, 必須加上事物處理結(jié)束的命令 COMMIT 才能正式生效, , 可以用命令 ROLLBACK , DELETE 和 UPDATE 語句前最好估算一下可能操作的記錄范圍，應(yīng)該把它限定在較小(一萬條記錄)范圍內(nèi),., 可以把這些SQL語句分段分次完成, 其間加上COMMIT (DDL)部分(創(chuàng)建表, 索引, 視圖, 同義詞, 過程, 函數(shù), 數(shù)據(jù)庫鏈接等)ORACLE常用的字段類型有CHAR 固定長度的字符串 VARCHAR2 可變長度的字符串NUMBER(M,N)數(shù)字型M是位數(shù)總長度, N是小數(shù)的長度 DATE 日期類型創(chuàng)建表時(shí)要把較小的不為空的字段放在前面, 可能為空的字段放在后面 創(chuàng)建表時(shí)可以用中文的字段名, 但