Operational processes for Oracle databases

1. Create a table space first

Create tablespace tablespace name datafile data file path (data file with DBF suffix) size data file, default storage (initial 128K next 128K maxextents Unlimi Ted Pctincrease 0) minimum extent 128K; The red part indicates that the initialization size of the tablespace is 128K when the table space is used up the next size is 128K and the size of the tablespace is not capped, the minimum step is 128K.

Tip: Don't forget commit when you're done creating a tablespace

2. Create a user after creating a tablespace

Create user username identified by password default tablespace table space;

3. Assigning roles to users

Grant DBA to User name; The DBA is the highest privilege for the user.

4. When the user is created, the table is built.

CREATE TABLE table name (field name 1 type 1,

Field Name 2 Type 1,

......,

Field name n type N);

Operational processes for Oracle databases