Four steps of creating table space and user in Oracle

Time:2021-6-23

/*There are four steps*/

/*Step 1: create a temporary table space (Note: D: project, oracletablespace, fhaddmin, create path manually)  */

create temporary tablespace C##FHADMIN_TEMP  

tempfile 'D:\Project\OracleTableSpace\FHADMIN\C##FHADMIN_TEMP.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;

/*Step 2: create the data table space fhadm.org   */

create tablespace C##FHADMIN_DATA

logging  

datafile 'D:\Project\OracleTableSpace\FHADMIN\C##FHADMIN_DATA.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;

/*Step 3: create a user and specify that the table space password is root*/

create user C##FHADMIN identified by root

default tablespace C##FHADMIN_DATA

temporary tablespace C##FHADMIN_TEMP;

/*Step 4: give the user permission to fhadmin.org  */

grant connect,resource,dba to C##FHADMIN;

 

Official website:www.fhadmin.org

———————–Separation of spring boot framework vue.js————–

 

[framework platform] springboot framework vue.js separates fashion style

 

Instant messaging: support friends, groups, send pictures, files, messages, voice reminders, offline messages, keep chat records

 

(the instant chat function supports the mobile terminal, and the details are shown below)

 

Workflow module———————————————————————————————————-

 

1. Model management     : Web online process designer, preview process XML, export XML, deploy process

 

2. Process management     : Import and export process resource file, view process diagram, reflect process model according to process instance, activate suspend

 

3. Running process: view process information, current task node, current flow chart, void and suspend process, assign to-do person

 

4. Historical process: view process information, process time, process status and task initiator information

 

5. To do tasks    : View my personal tasks and tasks under this role, handle, reject, void, and assign an agent

 

6. Tasks done    : Check the tasks you have handled, process information, flow chart and process status (normal completion)

Note:When the current task is finished, the next task to-do person will receive the new task message reminder through instant messaging, which will be regarded as the end of the task,
The task initiator will receive a message notification from the station

 

 

Recommended Today

Detailed explanation and practical drill of MySQL tuning explain tool (recommended)

Detailed explanation of MySQL tuning explain tool and practical drill explain tool introduction explain analysis example explain two variants explain column index best practical index Usage Summary:MySQL installation document reference Explain tool introduction Use the explain keyword to simulate the optimizer to execute SQL statements and analyze the performance bottlenecks of your query statements or […]