【正文】 oracle/oradata/mynewdb/39。查詢遠(yuǎn)端數(shù)據(jù)庫里的表SELECT …… FROM 表名數(shù)據(jù)庫鏈接名。GRANT SELECT ON 表名 TO 用戶名。 回收權(quán)限REVOKE CONNECT, RESOURCE FROM 用戶名。REVOKE SELECT, INSERT, DELETE ON表名 FROM 用戶名1, 用戶名2。6339。查詢報表數(shù)據(jù)庫中話單統(tǒng)計種類查詢。//增加一個新的日志文件組的語句 connect internal as sysdba alter database add logfile group 4(’/db01/oracle/CC1/’, ’/db02/oracle/CC1/’)size 5M。//在Server Manager上MOUNT并打開一個數(shù)據(jù)庫: connect internal as sysdba startup mount ORA1 exclusive。//生成數(shù)據(jù)字典 catalog catproc // 中備份數(shù)據(jù)庫的位置log_archive_dest_1 = ’/db00/arch’ log_archive_dest_state_1 = enable log_archive_dest_2 = “service= mandatory reopen=60” log_archive_dest_state_2 = enable //對用戶的表空間的指定和管理相關(guān)的語句create user USERNAME identified by PASSWORD default tablespace TABLESPACE_NAME。alter user SYSTEM quota 0 on SYSTEM。create user USERNAME identified by PASSWORD default tablespace DATA temporary tablespace TEMP。//重新指定一個數(shù)據(jù)文件的大小 : alter database datafile ’/db05/oracle/CC1/’ resize 200M。//在表空間上增加一個自動擴(kuò)展的數(shù)據(jù)文件: alter tablespace DATA add datafile ’/db05/oracle/CC1/’ size 50M autoextend ON maxsize 300M。//在數(shù)據(jù)文件移動期間重新命名: alter database rename file ’/db01/oracle/CC1/’ to ’/db02/oracle/CC1/’。alter database rename file ’/db05/oracle/CC1/’ to ’/db02/oracle/CC1/’。//創(chuàng)建和使用角色: create role APPLICATION_USER。grant APPLICATION_USER to username。alter rollback segment SEGMENT_NAME offline。alter rollback segment SEGMENT_NAME online。set transaction use rollback segment ROLL_BATCH。mit。select , /* rollback segment name */ /* rollback segment OPTIMAL size */ from V$ROLLNAME N, V$ROLLSTAT S where =。alter rollback segment R1 shrink。alter rollback segment R4 online。grant select on EMPLOYEE to PUBLIC。grant CREATE SESSION, CREATE USER, ALTER USER to ACCOUNT_CREATOR。alter user THUMPER default role CONNECT。alter profile DEFAULT limit idle_time 60。create user JANE identified by EYRE profile LIMITED_PROFILE。alter user JANE account unlock。alter profile LIMITED_PROFILE limit PASSWORD_LIFE_TIME 30。//創(chuàng)建操作系統(tǒng)用戶REM Creating OPS$ accounts create user OPS$FARMER identified by SOME_PASSWORD default tablespace USERS temporary tablespace TEMP。//執(zhí)行ORAPWD ORAPWD FILE=filename PASSWORD=password ENTRIES=max_users create role APPLICATION_USER。create role DATA_ENTRY_CLERK。grant select, insert on to DATA_ENTRY_CLERK。grant APPLICATION_USER to DATA_ENTRY_CLERK。grant DATA_ENTRY_CLERK to BPOTTER with admin option。set role NONE。revoke all on EMPLOYEE from MCGREGOR。drop user USERNAME cascade。grant SELECT on to BPOTTER with grant option。create user MCGREGOR identified by VALUES ’1A2DD3CCEE354DFA’。//備份與恢復(fù)使用 export 程序exp system/manager file= press=Y owner=(HR,THUMPER)exp system/manager file= owner=HR indexes=Y press=Y imp system/manager file= full=Y buffer=64000 mit=YMartriWang 14/05/20071 將數(shù)據(jù)庫TEST完全導(dǎo)出,用戶名system 密碼manager 導(dǎo)出到D:exp system/managerTEST file=d: full=y 2 將數(shù)據(jù)庫中system用戶與sys用戶的表導(dǎo)出exp system/managerTEST file=d: owner=(system,sys)3 將數(shù)據(jù)庫中的表tabletable2導(dǎo)出exp system/managerTEST file=d: tables=(table1,table2)4 將數(shù)據(jù)庫中的表table1中的字段filed1以“00”打頭的數(shù)據(jù)導(dǎo)出exp system/managerTEST file=d: tables=(table1)query=“ where filed1 like 39?！盡artriWang 14/05/20071 將數(shù)據(jù)庫TEST完全導(dǎo)出,用戶名system 密碼manager 導(dǎo)出到D:exp system/managerTEST file=d: full=y 2 將數(shù)據(jù)庫中system用戶與sys用戶的表導(dǎo)出exp system/managerTEST file=d: owner=(system,sys)3 將數(shù)據(jù)庫中的表tabletable2導(dǎo)出exp system/managerTEST file=d: tables=(table1,table2)4 將數(shù)據(jù)庫中的表table1中的字段filed1以“00”打頭的數(shù)據(jù)導(dǎo)出exp system/managerTEST file=d: tables=(table1)query=“ where filed1 like 39?！?/備份表exp system/manager FILE= TABLES=()//備份分區(qū)exp system/manager FILE= TABLES=(:Part1)//輸入例子imp system/manager file= imp system/manager file= buffer=64000 mit=Y exp system/manager file= owner=thumper grants=N indexes=Y press=Y rows=Y imp system/manager file= FROMUSER=thumper TOUSER=flower rows=Y indexes=Y imp system/manager file= full=Y mit=Y buffer=64000 imp system/manager file= ignore=N rows=N mit=Y buffer=64000 //使用操作系統(tǒng)備份命令 REM TAR examples tarcvf /dev/rmt/0hc /db0[19]/oracle/CC1tarrvf /dev/rmt/0hc /orasw/app/oracle/CC1/pfile/ tarrvf /dev/rmt/0hc /db0[19]/oracle/CC1 /orasw/app/oracle/CC1/pfile/ //離線備份的shell腳本ORACLE_SID=cc1。export svrmgrl connect internal as sysdba shutdown immediate。alter database archivelog。alter database open。LOCATION=/oracle/oradata/szdb/archive39。%t_%39。alter system set log_archive_start=true scope=spfile。alter database noarchivelog。archive log list select Name, Value from V$PARAMETER where Name like ’log_archive%’。export ORACLE_SIDORAENV_ASK=NO。!tarcvf /dev/rmt/0hc /db01/oracle/CC1/ alter tablespace SYSTEM end backup。!tarrvf /dev/rmt/0hc /db02/oracle/CC1/ alter tablespace RBS end backup。!tarrvf /dev/rmt/0hc /db03/oracle/CC1/data0*.dbf alter tablespace DATA end backup。!tarrvf /dev/rmt/0hc /db04/oracle/CC1/ alter tablespace INDEXES end backup。!tarrvf /dev/rmt/0hc /db05/oracle/CC1/ alter tablespace TEMP end backup。export FILES Now go back into Server Manager and restart the archiving an indicator(called EOFarch2 in this example). svrmgrl connect internal archive log start。exit EOFarch3 備份控制文件到磁帶. tarrvf /dev/rmt/0hc /db01/oracle/CC1/ End of hot backup script.//自動生成開始備份的腳本set pagesize 0 feedback off select ’alter tablespace ’||Tablespace_Name||’ begin backup。’ from DBA_TABLESPACES where Status ’INVALID’ spool / spool off // See text for alternatives. Step 1: Stop the archiving will keep additional archived redo log files from being written to the destination directory during this process. svrmgrl connect i