Oracle management Note 2

1. Create role modify role ALTERROLE role name NOTIDENTIFIEDIDENTIFIEDBY password EXTERNALLY33. Delete role droprole role name 4. append data file altertablespace tablespace name adddatafile file description (file name size1m) rename

1. create role acct identified by bicent 2. modify role alter role name not identified identifiedby password EXTERNALLY 3. delete role drop role name 4. alter tablespace table space name add datafile description (file name size 1 m) rename

1. Create a role

Create role acct identified by bicent

2. modify a role

Alter role name NOT IDENTIFIED

Identified by password

EXTERNALLY3

3. delete a role

Drop role name

4. append data files

Alter tablespace name

Add datafile file description (file name size 1 m)

Rename datafile file name to file name

Defautl storage statement

Online

5. Add an online Log File Group

Alter database

Add logfile ('log1c. log', 'log2c. log') size 500 k

6. delete a log file group

Alter database

Drop logfile group3

7. Add online log file members

Alter database

Add logfile member 'log2b. log' to group 2

8. tablespace Management

Create tablespace user_stu

DATAFILE 'diska: user_stu1.dat 'SIZE 20 M

DEFAULT STORAGE

(INITIAL 10 K

NEXT 50 K

MINEXTENTS 1

MAXEXTENTS 99

PCTINCREASE 10)

ONLINE;

9. Create rollback segments

Create public rollback segment name

Tablespace name

Storage (inner 50 k

Next 50 k

Optimal 150 k

Maxextents 10

);

Online