-
编辑 删除
查看当前默认的表空间是否是大文件语句
select property_value from database_properties where property_name='DEFAULT_TBS_TYPE'[@more@]
-
编辑 删除
为数据库建立默认的临时表空间
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE tempts2;[@more@]
-
编辑 删除
手工创建数据库步骤
手工创建数据库时，按照以下步骤：Step 1: Decide on Your Instance Identifier (SID)Step 2: Establish the Database Administrator Authentication MethodStep 3: Create the Initialization Parameter FileStep 4: Connect to the InstanceStep 5: Create a Server Parameter File (Recommended)Step 6: Start the InstanceStep 7: Issue the CREATE DATABASE StatementStep 8: Create Additional TablespacesStep 9: Run Scripts to Build Data Dictionary ViewsStep 10: Run Scripts to Install Additional Options (Optional)Step 1
-
编辑 删除
显示控制文件的试图
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@]
-
编辑 删除
逻辑和物理上的数据库结构
[@more@]
-
编辑 删除
开通blog，记录自己学习oracle之旅的点点滴滴
开通blog，是为了记录自己学习oracle之旅的点点滴滴，也算监督自己，没有偷懒。许久，回头看看自己曾经走过的路。[@more@]
-
编辑 删除
当用户以SYSDBA和SYSOPER这2个角色登录系统后，被授权的（允许）的操作选项
System PrivilegeOperations AuthorizedSYSDBAPerform STARTUP and SHUTDOWN operations ALTER DATABASE: open, mount, back up, or change character setCREATE DATABASEDROP DATABASECREATE SPFILEALTER DATABASE ARCHIVELOGALTER DATABASE RECOVERIncludes the RESTRICTED SESSION privilegeEffectively, this system privilege allows a user to connect as user SYS.SYSOPERPerform STARTUP and SHUTDOWN operations CREATE SPFILEALTER DATABASE OPEN/MOUNT/BACKUPALTER DATABASE ARCHIVELOGALTER DATABASE RECOVER (Complete recov
