ORACLE_8-8I开发使用手册 (29)

30SHOWINDEXFILE30.1Oracle8.xImportExportOracleOracle8.xOraclePoint-in-timeRecoveryOracleOracleOracle7Oracle8Oracle8CREATECREATEFILESIZEFILESIZEFILESIZE6464OSFILESIZEKFILESIZEFILESIZE=2KFILESIZE=2048M10241024G102410241024BFILESIZE=2048bFILESIZE=2048Oracle8iDBMS_RLS/Oracle8i••IGNORE=YIGNOREIGNORE•Oracle8iSQLSELECTWHERETABLESCOTT10UNIXQUERYUNIXSELECTQUERYTABLEEMPDEPTSQL496OracelOracleOracleOracleOracleACCESSOracleCVSSQL*LoaderOracleOracleOraclePL/SQLSQL*Plus30.2FULLOWNERTABLE30-1ExportOracle8expimpWindowsNTUNIXexpimp30-1/FULL=YOWNERTABLE30497/FULL=YOWNERTABLEROWIDSROWIDROWIDCOMPLETEREFROWIDREFROWIDREFANALYZETABLEowner.table_nameVALIDATEREFUPDATE30.3expEXP_FULL_DATABASESYSTEMexpdat.dmp1EY/NY/NY/N2UY/NY/NY/N3TY/NY/NY/NTTPWindowsNTexpHELP=Y30-12330-2498Oracel30-1WindowsNTexpHELP=Y30-2BUFFERBUFFERCOMPRESSYCOMPRESS=YINITIALCONSISTENTNCONSISTENT=YCONSISTENT=NCONSTRAINTSNDIRECTNDIRECT=YOracleSQLOracle8LOBFEEDBACK0OracleFEEDBACKFEEDBACK=10001000FILEexpdat.dmpexpdat.dmpdata.dumpFILEFULLNFULL=YFILESIZEGRANTSYHELPNHELP=YINCTYPEINCTYPECOMPLETECUMULATIVEINCREMENTALCOMPLETECUMULATIVECUMULATIVECOMPLETEINCREMENTALINCREMENTALCUMULATIVECOMPLETE30499INDEXESYOIDINDEXESLOGLOGOracle.LOGPARFILEPARFILEPOINT_IN_NTABLESPACESTIME_RECOVERQUERYWHERERECORDYRECORD=YINCTYPESYSINCEXPINCFILEINCVIDRECORD_LENGTHRECORDLENGTHRECOVERY_RECOVERY_TABLESPACESPOINT_IN_TIME_RECOVERTABLESPACESROWSYROWS=NSTATISTICSESTIMATECOMPUTEESTIMATENONETABLESFROMUSERUNIXWindowsNTTABLESPACESPOINT_IN_TIME_RECOVERUSERID/NET8@VOLSIZEVOLSIZEVOLSIZE64impDBAIMP_FULL_DATABASEDBASYSTEMexpdat.dmp/SHOWINDEXFILE/500OracelimpHELP=Y30-230-2WindowsNTimpHELP=Y2730-330-3ANALYZEYANALYZEYESTIMATEDSTATISTICS=COMPUTEBUFFERBUFFERCHARSETCHARSETOracle6ASCIIEBCDICOracle7Oracle8COMMITNCOMMIT=YDESTROYNDESTROY=YOracleDESTROY=YFEEDBACK0OracleFEEDBACKFEEDBACK=1000100030501FILEexpdat.dmpexpdat.dmpdata.dumpexpdat.dmpFILEFILESIZEFROMUSERFROMUSERFULLNFULL=YGRANTSYHELPNHELP=YIGNORENIGNORE=YINCTYPESYSTEMINCTYPE=SYSTEMINCTYPE=RESTOREINDEXESYOIDINDEXESINDEXFILEINDEXFILECREAETINDEXOracle.SQLINDEXFILELOGLOGOracle.LOGPARFILEPARFILEPOINT_IN_TIMENTABLESPACESRECOVERRECORDLENGTHRECORDLENGTHRECALCULATE_NSTATISTICSSHOWNSHOWSQLFILESQLSHOWINDEXFILESHOWSKIP_UNUSABLE_NSKIP_UNUSABLE_INDEXESINDEXESINDEXINDEXES=YTABLESFROMUSERUNIXWindowsNTTOUSERTOUSERFROMUSERTOID_NOVALIDATETOIDTOID502OracelTOID_NOVALIDATETOIDUSERID/NET8@30.430.4.130-3IGNORE=YDEMOEMPLOYEE30-430-43050330-330.4.2OracleOracle30-530-5OracleCHP30_1.SQL30-1SQL*PLUSOracle830-1CHP_30.SQL504Oracel112,1112,11,2FILE_NAMEALTERTABLESPACECOALESCECHP30_1.SQLCOMPRESS=YOracleCHP30_2.SQL30-230-2CHP30_2.SQL1COMPRESS=YINITIAL23ALTERTABLESPACECOALESCE4OracleCOMPRESS=YCOMPRESS=YLOBINITIALNEXTCREATEDATABASE3050530.4.3506Oracel30-6DEMOQUE30-7DEMOOWNERDEMOQUE30-6FROMUSERTOUSER30-730-8DEMOQUEBFILEOracleOracleBFILE30.4.4TABLESFROMUSERTOUSER..30-9PRICEEMPLOW_SALARYMEDIUM_SALARY3050730-9FROMUSERTOUSERFULL=YOWNER30.4.530.4.6OracleDBA_TOOLSDBA_TOOLSDBA_TOOLS508Oracel30.4.7OracleUSER_ATABLESPACE_ATABLESPACE_B1)USER_ATABLESPACE_A2)REVOKEUNLIMITEDTABLESPACEONTABLESPACE_AFROMUSER_A;3)ALTERUSERUSER_AQUOTA0ONTABLESPACE_A;USER_ATABLESPACE_A4)TABLESPACE_AUSER_A5)ALTERUSERUSER_ADEFAULTTABLESPACETABLESPACE_B;TABLESPACE_BUSER_AOracleTABLESPACE_ATABLESPACE_ATABLESPACE_AOracleTABLESPACE_BUSER_A6)ALTERUSERUSER_AQUOTAUNLIMITEDONTABLESPACE_B;USER_ATABLESPACE_B7)TABLESPACE_AUSER_ATABLESPACE_BSQLSHOWINDEXFILE30.5SHOWINDEXFILESHOWSQLSHOW30-3SHOW=Y30-3CHP30_3.lstSHOW=Y30509LOG=Oracle30-430-4CHP30_4.lstSHOW=YSQLINDEXFILECREATEINDEXINDEXFILEOracle.SQLINDEXFILECREATE30-5INDEXFILE=X.LOGX.LOGOracle510Oracel30-5X.LOGINDEXFILE=X.LOGX.LOG30.6OracleOracle//OLTP30511