Oracle创建用户

创建表空间:

CREATE TEMPORARY TABLESPACE BJAIC_RULE_TEMP TEMPFILE '/home/oracle_datefile/biaic_rule/BJAIC_RULE_TEMP.dbf' SIZE 1024M AUTOEXTEND ON NEXT 500M EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE BJAIC_RULE LOGGING DATAFILE '/home/oracle_datefile/biaic_rule/BJAIC_RULE.dbf' SIZE 1024M AUTOEXTEND ON NEXT 500M;

查看表空间:

SELECT tablespace_name, file_id, file_name, round(bytes / (1024 * 1024), 0) as total_space
FROM dba_data_files
ORDER BY bytes desc, tablespace_name
;

创建用户:

pl/sql 中，Objects/My Objects/Users

点右键，添加。

 

转载于:https://www.cnblogs.com/liuhailong2008/p/4055259.html