vmware workstation 6.5 网络配置-Part1
1.虚拟网设备
vmware workstation 可通过以下三中选项来配置虚拟机的虚拟网络
(a)Bridged
(b)NAT(network address translation)
(c)Host-only
Continue reading vmware workstation 6.5 网络配置-Part1
1.Enable archiving Mode
(1)Shutdown the database.
(2)Start the database in Mount state.
(3)Set the database in Archivelog mode by using the ALTER DATABASE command.
ALTER DATABASE ARCHIVELOG; |
(4)Open the database.
(5)Take a full backup of the database.
Continue reading Configuring the Database Archiving Mode
1.Categories of Failures
.Statement failure
.User process failure
.user error
.Instance failure
.Media failure
.Network failure
Continue reading Backup and Recovery Overview
1.Security Domain
Authentication Mechanism
. Data Dictionary
. Operating system
. Network
Syntax
Use the following command to create a new user:
1
2
3
4
5
6
7
8
9
10
| CREATE USER user
IDENTIFIED {BY password | EXTERNALLY}
[ DEFAULT TABLESPACE tablespace ]
[ TEMPORARY TABLESPACE tablespace ]
[ QUOTA {integer [K | M ] | UNLIMITED } ON tablespace
[ QUOTA {integer [K | M ] | UNLIMITED } ON tablespace
]...]
[ PASSWORD EXPIRE ]
[ ACCOUNT { LOCK | UNLOCK }]
[ PROFILE { profile | DEFAULT }] |
Continue reading Managing User
1.Two Types of Oracle user privileges
1
2
3
4
5
6
7
8
| . System privilege:Enables users to perform particular actions in the database
. Object:Enables users to access and manipulate a specific object
. There is no CREATE INDEX privilege.
. CREATE TABLE includes the CREATE INDEX and the ANALYZE commands. The user
must have a quota for the tablespace or must have been granted UNLIMITE TABLESPACE.
. Privileges such as CREATE TABLE, CREATE PROCEDURE, or CREATE CLUSTER include the dropping of these objects.
. UNLIMITED TABLESPACE cannot be granted to a role.
. For truncating a table in another schema, the DROP ANY TABLE privilege is necessary. |
Continue reading Managing Privileges
Recent Comments