Oracle additions and deletions--the increase

Oracle additions and deletions--the increase

1. Create new database user and set password create user username identified by password

2. Authorize DBA Grant DBA to user name for new user;

3, login authentication Feiyu user conn Feiyu;

4, CREATE TABLE (first cut to current user) CREATE TABLE table name (ID number (6) NOT null primary Key,id_username char (4));

5. Add data to Chengji table insert into table name values (' 2 ', ' wfy ');

6. Create a standard index named Cheng_index for the Id_username column under the Cheng table
Create index index name on table name (field name); (Field name is viewed first)

7, re-index alter the name rebuild;

Oracle additions and deletions--the increase