oracle语句
-
编辑 删除
查看当前默认的表空间是否是大文件语句
select property_value from database_properties where property_name='DEFAULT_TBS_TYPE'[@more@]
-
编辑 删除
为数据库建立默认的临时表空间
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE tempts2;[@more@]
-
编辑 删除
显示控制文件的试图
The following views display information about control files:ViewDescriptionV$DATABASEDisplays database information from the control fileV$CONTROLFILELists the names of control filesV$CONTROLFILE_RECORD_SECTIONDisplays information about control file record sectionsV$PARAMETERDisplays the names of control files as specified in the CONTROL_FILES initialization parameter[@more@]
-
编辑 删除
查询日志文件、数据文件和控制文件的sql语句
查询日志文件：SELECT MEMBER FROM V$LOGFILE;查询数据文件：SELECT NAME FROM V$DATAFILE; 查询控制文件：SELECT VALUE FROM V$PARAMETER WHERE NAME = 'control_files'; [@more@]
