Oracle数据库管理员手册018

ADBASQL1.ALTERDATABASE436ADBASQL437ALTERDATABASEOracle8iOracle8iOracle8iATLERDATABASERECOVEROSDBAdatabaseASCIIOracleDB_NAMECONTROL_FILESNet8•MOUNT•STANDBYDATABASEOracle8i•CLONEDATABASEOracle8i•CONVERTOracle7OracleOracle7Oracle8iOracle8i•ACTIVATESTANDBYDATABASEOracle8i•OPEN•READONLYREADWRITEREADONLYREADONLYREADONLYREADONLY•READWRITE•RESETLOGS1438RECOVER•NORESETLOGSRESETLOGSNORESETLOGSOracleNORESETLOGS•general_recovery_clauseOracle8iOracleSQL*PlusRECOVERSQL*PlusOracle•AUTOMATICOracleLOG_ARCHIVE_DESTLOG_ARCHIVE_DEST_1LOG_ARCHIVE_FORMATOracleAUTOMATICLOGFILEOracleOracleLOGFILE•FROMlocationlocationOracleLOG_ARCHIVE_DESTLOG_ARCHIVE_DEST_1•STANDBYDATABASE•DATABASE•UNTIL•CANCELRECOVERCANCELALTERDATABASERECOVER•TIMEYYYY-MM-DDHH24MISS•CHANGEintegerSCNADBASQL439•USINGBACKUPCONTROLFILE•TABLESPACE•DATAFILE•STANDBYTABLESPACE|DATAFILE•UNTIL[CONSISTENTWITH]CONTROLFILECONSISTENTWITH•LOGFILE•CONTINUE•CONTINUEDEFAULTOracleOracleAUTOMATIC•CANCEL•managed_recovery_clauseOracle8igeneral_recovery_clause•TIMEOUTintegerintegerRECOVERCANCEL•CANCEL•CANCELIMMEDIATERECOVERMANAGEDSTANDBYDATABASE•parallel_clause•NOPARALLEL•PARALLELOracleCPUPARALLEL_THREADS_PER_CPU•PARALLELintegerOracleinteger•RENAMEGLOBAL_NAMEdatabase8domainOracle8i440•RENAMEFILE•RESETCOMPATIBILITYOracleRESETCOMPATIBILITYOracleOracleOracle8i•ENABLETHREAD•PUBLICTHREADPUBLIC•DISABLETHREAD•CHARACTERSET/NATIONALCHARACTERSETCHARACTERSETNATIONALCHARACTERSETNCHARNCLOBNVARCHAR2character_setALTERDATABASECHARACTERSETALTERDATABASENATIONALCHARACTERSETSYSDBASQL*PlusSTARTUPRESTRICTOracle8i•datafile/tempfile_clause•CREATEDATAFILEfilenamefilespecASOraclefilenameOracleSYSTEM•DATAFILE•ONLINEADBASQL441•OFFLINE•DROPNOARCHIVELOG•RESIZEKMOracle•autoextend_clause•OFFNEXTMAXSIZE0NEXTMAXSIZEALTERDATABASEAUTOEXTEND•ON•NEXTKM•MAXSIZE•UNLIMITED•ENDBACKUPSHUTDOWNABORTALTERTABLESPACE...ENDBACKUPOracle8i•TEMPFILEautoextend_clauseTEMPFILE•DROPtempfile•logfile_clause•ARCHIVELOG•NOARCHIVELOGARCHIVELOGNOARCHIVELOG•ADDLOGFILE•THREADintegerOracleParallelServerTHREAD•GROUPinteger1MAXLOGFILESGROUPOracleV$LOG442GROUP•filespecfilespec•ADDLOGFILEMEMBERfilenameREUSEOracle•GROUPintegerGROUP•listoffilename•DROPLOGFILEADDLOGFILEMEMBER•ALTERSYSTEMSWITCHLOGFILE••2•DROPLOGFILEMEMBERfilename•ALERSYSTEMSWITCHLOGFILE•DROPLOGFILE•CLEARLOGFILECLEARLOGFILE1)2)•UNARCHIVEDUNARCHIVEDUNARCHIVEDCLEARLOGFILE,CLEARLOGFILEI/O•UNRECOVERABLEDATAFILEARCHIVELOGDROPALTERDATABASE...DATAFILEOFFLINEUNRECOVERABLEDATAFILECLEARLOGFILEADBASQL443controlfile_clauses•CREATESTANDBYCONTROLFILEOracle8iREUSE•BACKUPCONTROLFILE•TOfilenameREUSE•TOTRACESQLSQL•RESETLOGSSQLALTERDATABASEOPENRESETLOGS•NORESETLOGSSQLALTERDATABASEOPENNORESETLOGS2.ALTERINDEX444ADBASQL445446ALTERANYINDEX•schemaschemaOracle•indexindexPARAMETERSRENAMErebuild_clausePARAMETERSLOADINGFAILEDFAILEDREBUILDLOADIGNFAILEDOracle8i•deallocate_unused_clauseindexOracleindexOraclerebuild_clause•KEEPMINEXTENTSMINEXTENTSINITIALADBASQL447INITIALKEEP•allocate_extent_clauseOracle•SIZEKMSIZEOracle•DATAFILEDATAFILEOracle•INSTANCEINSTANCE_NUMBEROracleParallelServerNEXTPCTINCREASE•parallel_clause:DML•NOPARALLEL•PARALLELOracleCPUPARALLEL_THREADS_PER_CPU•PARALLELintegerOracleinteger•physical_attributes_clausePCTUSEDALTERINDEXALTERINDEX...MODIFYPARTITIONPCTFREEPCTFREEALTERINDEX•storage_clause•LOGGING|NOLOGGINGDirectLoaderSQL*LoaderINSERTLOGGINGNOLOGGINGNOLOGGINGNOLOGGINGARCHIVELOGLOGGINGNOLOGGINGLOGGINGDMLOracle8iOracle8i448•RECOVERABLE|UNRECOVERABLELOGGINGNOLOGGINGRECOVERABLEUNRECOVERABLEOracleLOGGINGNOLOGGINGRECOVERABLELOBUNRECOVERABLECREATEINDEXAS•rebuild_clausedeallocate_unused_clauseALTERINDEXALTERINDEX...MODIFYPARTITIONPCTFREEALTERINDEXPCTFREE•PARTITIONpartitionOracle8iREBUILDSUBPARTITION•SUBPARTITIONsubpartitionTABLESPACETABLESPACEparallel_clause•REVERSE|NOREVERSE•REVERSE•NOREVERSENOREVERSEREVERSEREVERSENOREVERSE•TABLESPACE•COMPRESSinteger•111•1OracleCOMPRESS•NOCOMPRESSADBASQL449•ONLINEDMLDMLONLINEDMLOracle•COMPUTESTATISTICSSQLOraclePL/SQLOracle8i•LOGGING|NOLOGGINGALTERINDEX...REBUILD•PARAMETERSrebuild_clause1000Oracle8iindexUNUSABLE•ENABLE•••DETERMINISTICENABLEALTERINDEX•DISABLEENABLEALTERINDEX•UNUSABLEUNUSABLEUNUSABLE•RENAMETOindexnew_index_namenew_index_name•COALESCEOracleOracle8i•partitioning_clausesALTERINDEXALTERINDEXRENAMEREBUILD•modify_default_attributes_clause450TABLESPACE•TABLESPACE•LOGGING|NOLOGGING•FORPARTITIONpartition•modify_partition_clausepartitionphysical_attributes_clauseALTERTABLE...MODIFYDEFAULTATTRIBUTESOFPARTITION•rename_partition/subpartition_clausenew_name•drop_partition_clauseOracleUNUSABLE•split_partition_clauseUNUSABLEUNUSABLE•AT(value_list)split_partition_1()value_listpartition_name_old•INTO•partition_description•modify_subpartition_clauseUNUSABLE3.ALTERMATERIALIZEDVIEW/SNAPSHOT/ADBASQL451452mastertables,detailtables,Oracle8iOracle8iALTERANYSNAPSHOTALTERANYMATERIALIZEDVIEW•QUERYREWRITE•GLOBALQUERYREWRITE•QUERYREWRITEALTERMATERIALIZEDVIEWOracle8i•schemaschemaOracle•materializedview/snapshot•physical_attributes_clausePCTFREEPCTUSEDINITRANSMAXTRANSOracle•LOGGING|NOLOGGING•CACH