-
编辑 删除
手工创建数据库步骤
手工创建数据库时，按照以下步骤：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
-
编辑 删除
逻辑和物理上的数据库结构
[@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
