March 2010
M T W T F S S
« Feb    
1234567
891011121314
15161718192021
22232425262728
293031  

vmware workstation 6.5 网络配置-Part1

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

Configuring the Database Archiving Mode

1.Enable archiving Mode
(1)Shutdown the database.

   SHUTDOWN IMMEDIATE;

(2)Start the database in Mount state.

   STARTUP MOUNT;

(3)Set the database in Archivelog mode by using the ALTER DATABASE command.

  ALTER DATABASE ARCHIVELOG;

(4)Open the database.

  ALTER DATABASE OPEN;

(5)Take a full backup of the database.
Continue reading Configuring the Database Archiving Mode

Backup and Recovery Overview

1.Categories of Failures
.Statement failure
.User process failure
.user error
.Instance failure
.Media failure
.Network failure
Continue reading Backup and Recovery Overview

Managing User

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

Managing Privileges

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