电子杂志

ITPUBHOME::[e-mail]::[e-mail]2GBTheOracleDBA’sGuidetoNTOracleOSOracleDBAOracle(lob)Developer2000scriptORACLEOCPLZ0-024MRPCRMOracleApplications11iITPUB1HOME::[e-mail]@itpub.net2001ITPUB20012001WTO2001IT9112001…………20012002,2002ITPUB::[e-mail]2GB----2GborNOT2Gb-FilelimitsinORACLE2GB2GB2GBUnix2GB2GB2GBExport2GBSQL*Loader2GBORACLE2GB2GBCPU(API)32word32API32word32word310x7FFFFFFF+21474836472GB12GB2GB3264ORACLE4GB0xFFFFFFFF42949672954GB11320x00000000324GB32ORACLE1.2GB+2.2GB+IOAPI3.ORACLEAPIORACLE64APIORACLE7.3APIORACLEpatchORACLE64APIexportSQL*LOADERITPUB2GBHOME::[e-mail]2GB+/ORACLEORACLE710222GB2044GBORACLE8ORACLE810222044GB2GB15/8GB4/2GBIO(serialised)2GBpatchAIXORACLEORACLEORACLEDB_BLOCK_SIZEUnixNTVMS4194302*DB_BLOCK_SIZEAlert[NOTE:112011.1]AUTOEXTENDMAXSIZE2GB[BUG:568232]ORACLEORA-600[3292]ORACLE2GB2GBUnixDB_BLOCK_SIZEITPUB2GBHOME::[e-mail]2GBORACLEORA-01119ErrorincreatingdatafilexxxxORA-27044unabletowriteheaderblockoffileSVR4Error:22:InvalidargumentORA-19502writeerroronfile'filename',blocknox(blocksize=nn)ORA-27070skgfdisp:asyncread/writefailedORA-02237invalidfilesizeKCF:write/openerrordba=xxxxxxblock=xxxxonline=xxxxfile=xxxxxxxxfilelimitexceed.Unixerror27,EFBIGExportand2Gb2GbExportFileSizeexportAPIexport2GB2GBUnix/ORACLE8i2GBORACLEextent2GB.ORACLEexportcompress=yNext2GBignore=yimport[BUG:708790][NOTE:62436.1]2GB+export..exportingtableBIGEXPORTEXP-00015:erroronrow10660oftableBIGEXPORT,columnMYCOL,datatype96EXP-00002:errorinwritingtoexportfileEXP-00002:errorinwritingtoexportfileEXP-00000:Exportterminatedunsuccessfully[BUG:185855]createtablespacebytesimport2GBora-2237(Mbytes)ITPUB2GBHOME::[e-mail]4GB.2GB8i[BUG:490190]SQL*Loaderand2GbSQL*Loader2GBSQL*Loader-500:Unabletoopenfile(bigfile.dat)SVR4Error:79:Valuetoolargefordefineddatatype[NOTE:30528.1]ORACLE8.0.6discardlog[BUG:948460][BUG:749600]discardORACLE2GB2GBORACLE8.0.564ORACLE8.0.5README[NOTE:62252.1]DBV2GBDBV-100[BUG:710888]2GBSQLdatafile...SizexxxxxMKORA-02237invalidfilesizeORACLE7.3.4quotas2GBEgALTERUSERusernameQUOTA2500MONtablespacenamereportsORA-2187invalidquotaspecification[BUG:425831]unlimitedtablesapacespoolspool2GBPlatformSee~~~~~~~~~~~AIX(RS6000/SP)[NOTE:60888.1]HP[NOTE:62407.1]DigitalUnix[NOTE:62426.1]ITPUB2GBHOME::[e-mail][NOTE:62415.1]SunSolaris[NOTE:62409.1]WindowsNTMaximum4GbfilesonFATTheoretical16TbonNTFS**See[NOTE:67421.1]beforeusinglargefilesonNTwithORACLE8**2ThereisaproblemwithDBVERIFYon8.1.6See[BUG:1372172]**3Thereisaproblemwith8.1.6/8.1.7whereanautoextendto4Gbcancauseacrash-see[BUG:1668488]metalink.ORACLE.comexport1./dev/rlvtest2.(Unixmknod/tmp/imp_pipepcompress/tmp/exp_pipeexport.dmp.Z&expfile=/tmp/exp_pipeuserid=xxx/xxxtables=...mknod/tmp/imp_pipepuncompressexport.dmp.Z/tmp/imp_pipe&impfile=/tmp/imp_pipeuserid=xxx/xxxtables=...3./:(ksh)echo|expfile=(compress|split-b1024m-expdmp-)userid=xxx/xxxtables=...echo|impfile=(catexpdmp-*|zcat)userid=xxx/xxxtables=...(chao_ping)4.expfile=/dev/rmt0....5ORACLE8i+filesizefileITPUBTheOracleDBA'sGuidetoNTHOME::[e-mail]’sGuidetoNTWindowsNTOracle80OracleDigitalVAXVAXVMSOracleOracleDG-OSMVSUnix87OracleVMS80OracleUnix90OracleUnixVMSUnix2000VMSUnixUnixWindowsOracleWindowsOracleUnixWindowsWindowsOracleUnixWindowsOracleWindowsOracleOracleOracleIntelWindows95OracleIBMS/MVSOracleOracleSGASQLMTSdbwrlgwrpmonsmonarc0OracleServerDispatcherServerListenerOracleWindowsUnixOracleUnixOracleOracleServerSGAUnixITPUBTheOracleDBA'sGuidetoNTHOME::[e-mail]cleNT2UnixOracleNTOracleUnixNTOracleOracleOSOracleNTOracleNTOracleOracleNTOracleNT/OracleOracleNT4.04GB2GOracle2GB2GOracleSGANT4NT1GBOracle3GbAlphaITPUBTheOracleDBA'sGuidetoNTHOME::[e-mail]racleNTOracle8ConnectionPoolConcentratingWindows200032GBOracleUnixdbstart/dbshutsvrmgrlsqlplus/OracleOracleMountOpenOracledaemonizeOracleWindowsOracleOracleNTNTOracleOracleServicesidNTOracleOracleService%SID%SIDABCOracleServiceABCOracleMountOpenOpenOracleStartsidOracle8Oracle8iOracleServiceSidOracleTNSListenerOracleListenerlistenerOracleAutonetstartOracleServiceGDB1netstartOracleStartGDB1netstartOracleTNSListener80oradimOracleServicesvrmgrlsqlplusOracleNTOracleOracleshutdownabortOracleOracleOracle88iOracleora_shutdownora_sid_shutdownOra_shutdown_typeOra_shutdown_timeoutNTora_sid_shutdowntype=Iora_sid_shutdow_timeout=30Oracleshutdownimmediate30NTshutdownabortOracleUnixOracleOracleOracle_HOME$ORACLE_HOMEITPUBTheOracleDBA'sGuidetoNTHOME::[e-mail]_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMEUnixOracleOSexpRmanexpUnixNTN