ITPub博客

BFILENAME BFILENAME returns a BFILE locator that is associated with a physical LOB binary file on the server file system.FILEISOPEN FunctionThis function finds out whether a BFILE was opened with the given FILE locator.SyntaxDBMS_LOB.FILEISOPEN ( file_loc IN BFILE) RETURN INTEGER; LOADFROMFILE Procedure This procedure copies all, or a part of, a source external LOB (BFILE) to a destination internal LOB. Syntax DBMS_LOB.LOADFROMFILE ( dest_lob IN OUT NOCOPY BLOB, src_

[oracle@RAC1 ~]$ crs_stat -tName Type Target State Host------------------------------------------------------------ora....11.inst application ONLINE ONLINE rac1ora....12.inst application ONLINE OFFLINEora.RACDB1.db application ONLINE ONLINE rac1ora....SM1.asm application ONLINE ONLINE rac1ora....C1.lsnr application ONLINE ONLINE rac1ora.rac1.gsd application ONLINE ONLINE rac1ora.rac1.ons application ONLINE O

首先利用DBCA创建模板文件test_dbca_silent，然后利用下面的命令创建数据库 in silent mode.C:windowssystem32>dbca -createDatabase -templateName "D:optoracleproduct10.2.0db_1assistantsdbcatemplatestest_dbca_silent.dbc" -gdbName jerry.cn -silent正在复制数据库文件1% 已完成3% 已完成11% 已完成18% 已完成26% 已完成37% 已完成正在创建并启动 Oracle 实例40% 已完成45% 已完成50% 已完成55% 已完成56% 已完成60% 已完成62% 已完成正在进行数据库创建66% 已完成70% 已完成73% 已完成85% 已完成96% 已完成100% 已完

silent mode install oracle software./runInstaller -record -destinationFile /tmp/install.rsp./runInstaller -responseFile /tmp/install.rsp -silentsilent mode install oracle database./dbca ORACLE DBCA创建数据库DBCA template迁移ＤＢ（做实验) －＞ＯＫ　　数据库软件版本需要相同,新的数据库中用户需要重新启用,即首先解锁用户,再重新设置密码.并且要创建PASSWORD FILE，否则远程SYSDBA登录不了.在创建template过程中，数据库会自动关闭，然后重启。DBCA图形界面DBCA silent(做实验)手动创建（做实验)ORACLE INSTANCEemctl s

时区NLS_DATE_FORMATv$timezone_names,current_date,dbtimezone,sessiontimezone,localtimestamp,current_timestampselect dbtimezone from dual; --database zoneselect sessiontimezone from dual; --current zoneselect * from v$timezone_names;timestamptimestamp with time zonetimestamp with local time zoneyear -4712 to 9999timezone_hour -12 to 14timzone_minute 00 to 59SQL> create table tt1(d1 date,d2 timestamp,d3 timestamp with time zone,d4 timestamp with local time zone);Table created.SQL> insert i